ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   updating formula cells (https://www.excelbanter.com/excel-programming/369241-updating-formula-cells.html)

Carrguy

updating formula cells
 
The question I have for you is How to update a copied formula cell?

I have an excel spreadsheet and a formula cell in €œF98€
The formula is: =sum(F83:F97)-(F85)-(F92)-(F90)-(F87)
I then copied the formula using the paint brush to the following columns:
I98, K98, M98, O98, Q98.
Throughout my day I need to add to the original formula in F98
Example of addition: =sum(F83:F97)-(F85)-(F92)-(F90)-(F87)-(F84)
F84 being a new entryin the formula. Is there a way that I can update the
formulas automatically in the other cells after making changes the original
cell F98, without doing a copy with the paint brush to all the cells needing
the up-date.

Thank you for your help with this challenge


All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com