vba/macro help

I want to record the info on Sheet One to Sheet Two after I click the Command Button to print out Sheet One. Only the info in the cells on Sheet One change not the cell positions. The recorded cell info on Sheet Two, however, should display on seperate rows with each click of the Command Button. Similar to example below. This is how 2 Command Button calls would appear on Sheet Two. The code shown below does not advance the rows on Sheet Two. Can you please help?

Thank you in advance for any assistance.

 

     A3   B3    C3

12:50:54 PM 001

$7.00

12:51:52 PM 002 $7.00

 

 

 

Private Sub CommandButton1_Click()

‘ Print_Ticket Macro

‘ Print Ticket

 

‘ Keyboard Shortcut: Ctrl+Shift+P

    Range(“A1:C6”).Select

    ExecuteExcel4Macro “PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)”

 

    Range(“B3”).Select

    ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 + 1

End Sub

By: James

Leave a Reply

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