Add number to numbers already in a cell (continuing count)

[bjade5683]

I need a macro that would let me add numbers to numbers already in a cell. I need to keep a continuing count. For example, if 5 is already in the cell and I enter 6 i need the cell to be 11. Also, I have a macro that works for the whole worksheet, but I only need two columns (G,H). Trying to get this report done for work. Thanks!

[shg]

Why not just list the numbers down a column and add them in the normal fashion? If you use VBA (which would be required), you have no history of the numbers you've added, and Undo goes bye-bye.

[Leith Ross]

Hello bjade5683,

Welcome to the Forum!

Here are the VBA macros you need to accomplish this. Directions follow on how to install them.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S