Found a worable sollution.

1. Created an extra sheet within the first document, created all the
same fields that we need in the locked sheet the company sent us.


Code:
--------------------

Sheets("Export").Range("A2:A" & eRow).Copy Destination:=Sheets("Motion").Range("A2:A" & eRow)

--------------------


The other rows are pretty much the same.

Thank you for all your help.

(Btw. 'Excel 2003 VBA Programmer’s Reference' by Wrox was also a great
help.)


--
shart
------------------------------------------------------------------------
shart's Profile: http://www.excelforum.com/member.php...o&userid=29563
View this thread: http://www.excelforum.com/showthread...hreadid=492650