Clear number from both sheets

[adam]

Hi anyone,

I’m having a workbook with two sheets. How could I write a macro that would clear the value in column “C” of the sheet 2 when I clear the same value from any row between (F18 & F35) of the sheet 1?

Let’s say for example I have 0009 in column “C” of sheet 1 and 0009 in column “F” of the sheet 1. When the user clears the number from the sheet 1 the same would happen to the number in Sheet 2.

I hope this makes my question clear.

Any help on this would be kindly appreciated.

Thanks in advance.