Delete Row Containing "x" in ColumnA in 2 Worksheets

[Guest]

Hello, I would like to know if someone could help me out with a Macro, to
delete certain rows in certain Worksheets. Im working in a file that has
several Worksheets that work together. On column A of the Worksheets I have a
certain reference which is a number. The idea is to have a 3rd Worksheet to
control, for example to type in that control worksheet let's say in cell A1 a
certain number and to run the Macro which would delete the rows in Sheet 1
and 2 containing that number in Column A.

thanks!

 

[Don Guillett]

have a look in vba help index for FIND and then FINDNEXT.