I have 2 workbooks, one called "invoice" the other called "invoice log"


I can transfer the data from the "invoice" workbook to the "invoice log
workbook OK.

My problem is how do I save the transfered data in the "invoice log"
workbook and then do an auto shift down a row for when the next lot of
data is transfered from the "invoice " workbook.


--
seags
------------------------------------------------------------------------
seags's Profile: http://www.excelforum.com/member.php...o&userid=30993
View this thread: http://www.excelforum.com/showthread...hreadid=508358