Help Please

LUMPKCHA · Aug 2, 2018

I have 2 cells right next to each other. One cell contains 142. The other cell contains 66. When I add 1 unit to 66 I want it to automatically subtract from 142. Is this possible? Please help me. I would greatly appreciate it. Have a good day.

Pecoflyer · Aug 3, 2018

TWIMC OP has posted the same question https://www.excelguru.ca/forums/sho...ence-Between-Two-Worksheets&p=37982#post37982
The only difference is that the operation should happen between two sheets instead of one

Logit · Aug 4, 2018

.
Paste this macro into a routine module and run it from a command button on the worksheet :

Code:

Option Explicit


Sub AddnSub()
    Range("E3").Value = Range("E3").Value + Range("G3").Value '<-- Change cell reference as needed.
    Range("F3").Value = Range("F3").Value - Range("G3").Value '<-- Change cell reference as needed.
End Sub

Help Please

LUMPKCHA

New member

Pecoflyer

Admin Alumnus

Logit

Member

Attachments