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