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

you could use a custom function to reference the previous sheet

http://www.j-walk.com/ss/excel/tips/tip63.htm


"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

Slow down a little

You have posted this same question 4 times in the past hour.

See one reply to your first post.


Gord Dibben MS Excel MVP

On Sat, 02 Aug 2008 16:30:23 -0300, 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