Posts by Greezball

  • 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 . 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

    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?