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