Forum Discussion
Excel
Mar 12, 2022Iron Contributor
Dynamic Substract
Hello Everyone, I would like the number in cell C2 to decrease every time I add a number to the whole of the column C. I would like for any number I enter into the B column to be subtracted automat...
Excel
Mar 12, 2022Iron Contributor
Sir! is it possible to automatic change in C2 when we enter number in B2?
- HansVogelaarMar 12, 2022MVP
I think you want to do this row by row. I would not recommend that: you would not have a history of changes, and it would be very difficult to correct mistakes.
But if you really want it, you could use the Worksheet_Change event procedure. See the attached version (now a .xlsm workbook)
- ExcelMar 12, 2022Iron ContributorThank you so much sir
- Riny_van_EekelenMar 12, 2022Platinum Contributor
- ExcelMar 12, 2022Iron ContributorIt helps.
Thank you so much sir.