Add 1 to one cell and subtract 1 from another

[Noob861]

As the title suggests, how do I add to one cell and also subtract that same amount on another cell?

[HansDouwe]

With formulas, without VBA: If you want to add something to one cell and subtract the same amount from another cell, the results should be in other cells.
For example. You want add something to B1 and subtract the same amount from B2 and you want the results respectively in C1 and C2 and something is in A1.
Please try in C1: =B1+A1 and try in C2: =B2-A1.

If you don't want the results in other cells (but in the same cells), its not possible with formulas and you need VBA.

[Noob861]

How do I accomplish this with a VBA?

[HansDouwe]

I'm not a VBA-expert.
If you want a VBA-solution, please ask a moderator to move this thread to Excel programming / VBA / Macros.

[Noob861]

How do I go about doing that?

[HansDouwe]

You can contact the moderators directly via "Report Post" button below your post.

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

[MatrixMan]

As the title suggests, how do I add to one cell and also subtract that same amount on another cell?

Put this in the worksheet module of the sheet with the 3 cells.

Please Login or Register  to view this content.