Find and match cells

Giganews Newsgroups
Subject: Find and match cells
Posted by:  martin
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?