Find and match cells
 

Hello,

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?

Martin

Find and match cells
 

Must it be a macro?

Use VLOOKUP to get the data.

"Martin" wrote:

Hello,

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?

Martin