I need a simple macro that will go thru each row of a sheet1 and find each
occurance of column A in sheet 2 and for each occurance fill in the next
column of sheet 1 with the value of Column B from sheet 2.

I tried a vlookup formula which can be used to find the first occurance of
the value in Sheet 1 column A and will return the first match found in Sheet
2. The problem occurs when a second match is found, the vlookup does not see
it. In addition to the need to find the additional values associated with
the repeat numbers, the program needs to place the found value in sheet 1
for each occurance. If 3 values are found then it should fill in Col 2 with
the first found value, Col 3 with the second and so on....

Thanks in advance.