I'd like to start at the first row and step through each row of the first
sheet. The worksheet has 300 rows, so I'd like to automate the process.
The value should be at the end of the row selected.

"Otto Moehrbach" wrote:

How is the first cell selected? For instance, does the user select a cell
and then run the macro?
Where in the first sheet do you want the value placed that came from the
second sheet? HTH Otto
"Mr. Clean" <Mr. wrote in message
...
I need to write a VBA program (or a macro) that will select a cell from a
worksheet, then look for the same text in a cell in another worksheet (in
the
same workbook), then copy another cell in the row that the text is found,
then paste it in the first worksheet.