Hi all again,

This is the situation:

I have an invoice sheet that is printed out by the salesman. I woul
like to keep a record of details on the sheet whenever an invoice i
printed.

What i'm looking for is code for something that transfers the detail
in the cells to another worksheet but on a new line e.g:

Date Inv No Amount Salesman

22/07/05 1 £55.00 Bob
22/07/05 2 £10.50 Joan
22/07/05 2 £10.00 Joan
23/07/05 3 £20.00 Bart

All invoices are made on one worksheet and the sales info i
automatically deleted after each print.
All of the info will be on different cells scattered around the page.
Sorry if the question sounds a bit vague but i'm not sure how to g
about this.

Thanks for looking at the problem, i've always received great advic
here

--
chris10
-----------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...fo&userid=2516
View this thread: http://www.excelforum.com/showthread.php?threadid=38975