adamsm
01-30-2011, 11:53 PM
Hi,
I'm trying to figure out a Macro code that would delete the appropriate row form Sheet 2 when the code number in column F of the Sheet 1 is deleted.
Lets say for an example; the user writes a serial number such as 0133 in cell "O6" of the Sheet 1 and the code numbers that comes with it in the column "F" of the same sheet. When the user clears one of the code number such as 0001 and hit the "save data" button, how could it be made so that only the row containing 0001 with the serial number 0133 gets deleted.
I hope I've made my question clear.
Any help on this would be kindly appreciated.
I'm trying to figure out a Macro code that would delete the appropriate row form Sheet 2 when the code number in column F of the Sheet 1 is deleted.
Lets say for an example; the user writes a serial number such as 0133 in cell "O6" of the Sheet 1 and the code numbers that comes with it in the column "F" of the same sheet. When the user clears one of the code number such as 0001 and hit the "save data" button, how could it be made so that only the row containing 0001 with the serial number 0133 gets deleted.
I hope I've made my question clear.
Any help on this would be kindly appreciated.