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 . 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?
Command Button macro. One Click prints copies and increment
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!