I have a work book with data in several worksheets and one main sheet that
contains all the data. Column A contains an id number. I want to record a
macro that deletes a row from one worksheet, finds the corresponding row and
deletes it from the main sheet, then pastes it into a sheet that contains all
the deletions. How can I copy the value in column A and paste it into the
"Find What" box, or is there another way to do it? I'm using Excel 2002.