help please

[scottathomes]

Hi anyone, In VBA how can I check a cell in one sheet against a range
of cells in another sheet and then copy values from the 2nd sheet where
the cells matched ?

eg:
sheetA range: A1 contains a list of codes
sheetB range: B10:H100 each row contains a code in column b and then
relevant data in columns c to h.

I would want to look up aheetA range A1, see what code has been
selected then go to sheetB and check for that code in column b, and
where it matches put the contents of that row into sheetA range A10:g10
onwards.

Thanks.
Amy x

 

[JulieD]

Hi Amy

do you really need a VBA solution as the VLOOKUP function will do exactly
what you're after - check it out in help and let us know

Cheers
JulieD