Command Button macro. One Click prints copies and increment

  • Worksheet one contains Range A3:C3
    A3=NOW() B3 is Ticket Number beginning at 001, 002, 003...etc. C3 is a user input Ticket Price . Click command Button to print out Ticket to give customer. Simultaneously copy Range to Sheet Two, advancing Ticket Number.
    ****Whats The code to copy to sheet two each subsequent Ticket one row beneath the last?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!