Hi,

I am trying to copy data from sheet1 to sheet2.
I cannot use the regular copy and paste function because if I make changes
on the sheet1, will not reflate on the sheet2.

So I decided to use "=Sheet1!A2".
I can easily from the sheet2 drag it down and have exactly the data from the
sheet1.
My problem is that I work with a lot of data is each sheet, so if I use the
above function, it will take me all day trying to finish my work.

My question is:
Is there any way, using the function "vlookup" that I can use to copy data
from sheet1 (the entire column - over 6000 cells) to sheet2?

Your help could be appreciated.

Regards,
J. Miller