Hi

In column A in worksheet 1 I have a list of numbers. Column B is blank.

In column A of worksheet 2 I have a list of numbers , with further
reference numbers next to each in column B.

What I need to do is to have a routine which will compare each number n
column A in worksheet 2 to column A in worksheet 1. It needs to run for
as many numbers as there are , and stop at the last one in the column.

Where there is a match , the number in column B in worksheet 2 needs to
be transferred to column B worksheet 1 in the same row as the matching
number. Where there is no match , the cell remains blank

example

Ws 1
A B

1
2
3
4
5
6
7
8

Ws 2
A B

1 3457
3 8566
5 2332
7 3346

After match

Ws 1
A B

1 3457
2
3 8566
4
5 2332
6
7 3346
8

I hope this seems clear.


Any help appreciated.