Hi,

Basically what I have is two excel sheets. One extensive list of accounts
and one with a selection of accounts from the extensive list.

Sheet 1 has a selected list of account numbers in Col A (about 400). And
nothing in col B

sheet 2 has a total list of account numbers in Col A (about 3000). And data
in col B.

I need to find the accounts on sheet 1 in sheet 2, and copy the data in the
B col of sheet 2 into the b col of sheet 1 for the relative account number.

I'm looking at Selecting A1(a/c number) finding the account number in sheet
2, copy B2 from sheet 2, and pasting back in sheet one in B1, then move onto
A2, until the list is complete.

Can anyone help with this?

Thanks
Carl