I have created a Invoice template on sheet 1 and I want to transfer the
data entered onto a row with headers on sheet 2 and when the data is
entered into the template again on sheet 1 I want sheet 2 data to
record onto the next row.

Please help I have an Excel Bible and can't find the answer.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=503787