|Subject:||Find and match cells|
|Date:||Wed, 1 Aug 2007|
I have a list of values in sheet 1, from cell A1 and downwards. The range
changes all the time, eg. A1-A10, A1-1000 etc.
I want to set up a macro that matches all the values in this column with the
A column in sheet 2.
If some of the cells matches I want the macro to copy the value in the B
column of the same row as the matching cell in sheet 1 and paste it into
sheet 2 column B, next to the cell just found.
Any sugestions, please?