software

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
quot;Find Whatquot; box, or is there another way to do it? I'm using Excel 2002.

You've probably got something like FindWhat = quot;valuequot;; edit that part of the
..Find method statement to instead read FindWhat = Range(quot;A1quot;).value.
You'll need to replace the A1 with the correct cell reference (it may wind
up something like quot;Aquot;amp;RowNum, where RowNum is a variable you've set to
indicate the row whose value you're seeking).
HTH. --Brucequot;jbritquot; wrote:

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