Sending data from one sheet to another

[brownie4321]

Attached is a sample of what i need to accomplish. === Push.xlsx

In sheet 'enter' I want to add $currency$ to the cells in column B and push the 'PUSH' button to send that information to the appropriate cooresponding cell on the 'Tally' sheet.

I need this information to 'Tally' - to add. I have $15 in cell B4 in the 'Tally' sheet and if I add $5 to cell B4 in 'Enter' sheet and hit the 'PUSH' button, cell B4 in 'Tally' sheet should read $20. If there is nothing to add but zero(0), then the number in the cells on 'Tally' sheet should stay the same.

Need some help! Let me know how to get the cells to add by using the 'PUSH' button.

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.

Insert a button on your file (Developer->Insert-> Choose the 1st from the form controls). Then right click and assign this macro to it.

[brownie4321]

That worked perfectly. Thanks!
What do I need to add to the VBA to get the cells in 'Enter' sheet to return to zero once the button is pushed?

[arlu1201]

I made the additions to the code above.

[brownie4321]

Perfect! Thanks!