Hi.

I need a bit of code that:

When I enter data into A1 on Sheet 1 it automatically takes the data from column B on Sheet 2 and pastes it into column B on Sheet 1.

I don't want it to be row specific - so it will work on all rows on Sheet 1

I want to have a whole series of VLOOKUP maths on Sheet 2 that I can then hide.....

Thanks