Cvs to log and timestamp

A workbook contains 2 worksheets.
Sheet one cell A3 =NOW() B3 is a ticket number beginning with 1 and increases by 1 (1,2,3…x) each time the Command Button is clicked to print ticket.
Cell C3 is price of ticket. Ticket Price is the only user entry.
Copy A3:C3 on sheet1 to sheet 2
With each Print command , a new row of A3:C3 appears under the last.

My method just keeps replacing the last A3:C3 data with the new data.

By: James P

Leave a Reply

Your email address will not be published. Required fields are marked *