The below link by Ron would help

http://www.rondebruin.nl/copy2.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"Sverre" wrote:

I need a VB program to import data from the first row to the last row in
sheet 1 to sheet 2 . The data in sheet 1 contein up to 60000 rows. I can't
copy the whole cheet an past it into sheet 2 because it will destroy the
defined matrix in a Look up function. Can anyone help me. I have little
knowledge in VBA.