Thank you Jacob. I will try the program. I just have to change some statments.
Jacob Skaria skrev:
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.