ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying and updating formulas (https://www.excelbanter.com/excel-worksheet-functions/197355-copying-updating-formulas.html)

dimitry

Copying and updating formulas
 
I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula [f4 of the actual sheet= h4 of the previous] which is the
actual stock, based on the remainig of the previous. I would like to
have a way of copying the formula to all sheets and updating
automatically. Actually I have to do it one by on.
Many thanks beforehand
Dimitry

Southern Kiwi

Copying and updating formulas
 
dimitry wrote:
I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula [f4 of the actual sheet= h4 of the previous] which is the
actual stock, based on the remainig of the previous. I would like to
have a way of copying the formula to all sheets and updating
automatically. Actually I have to do it one by on.
Many thanks beforehand
Dimitry


copy - paste link


All times are GMT +1. The time now is 09:56 AM.

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