formula update in individual cells in a whole workbook
 

I'm working on a time sheet and work projection work book and need to know
how to get it to update the formula for each cell and page. the formula for
each cell pulls information from 4 different cells of one line on the time
sheet portion for one day and adds them toghter to give the amount of hours
the employee is projecting for that day. So how do I set Excel to take this
formula and change it for the next cell of the projection sheet???
--
QuietRanger

The reason you haven't gotten answer is probably that nobody understands what
you mean. You might want to post back and make it more understandable


Regards,

Peo Sjoblom

"QuietRanger" wrote:

I'm working on a time sheet and work projection work book and need to know
how to get it to update the formula for each cell and page. the formula for
each cell pulls information from 4 different cells of one line on the time
sheet portion for one day and adds them toghter to give the amount of hours
the employee is projecting for that day. So how do I set Excel to take this
formula and change it for the next cell of the projection sheet???
--
QuietRanger

Here is the original formula
=+'MAR 20-APR 2'!$I$17+'MAR 20-APR 2'!$P$!$I$17
Here is what it is being changed to
=+'MAR 20-APR 2'!$I$17+'MAR 20-APR 2'!$P$17+'MAR 20-APR 2'!$Q$17+'MAR 20-APR
2'!$S$17
now here is the braek down of the formula - the 'MAR 20-APR 2' refers to the
page where the information is, the !$I$ refers to the column and the 17
refers to the line. This is repeted 10 times on a different.

Now how do we get this new formula to copy 10 times per sheet on 26 sheets
in a workbook and change to what each sheet needed from it corresponding page
automaticly. This is something that I was able to do with excel 97. Ok smart
one do you have an answer? I would like to know how to do this. Besides
everyone probly understood,but didn't know any more how to do it then I do.
So be a little more respectful next time to everybody.

"Peo Sjoblom" wrote:

The reason you haven't gotten answer is probably that nobody understands what
you mean. You might want to post back and make it more understandable


Regards,

Peo Sjoblom

"QuietRanger" wrote:

I'm working on a time sheet and work projection work book and need to know
how to get it to update the formula for each cell and page. the formula for
each cell pulls information from 4 different cells of one line on the time
sheet portion for one day and adds them toghter to give the amount of hours
the employee is projecting for that day. So how do I set Excel to take this
formula and change it for the next cell of the projection sheet???
--
QuietRanger

Would you be so kind and tell us how you did it in Excel 97?

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"QuietRanger" wrote in message
...
Here is the original formula
=+'MAR 20-APR 2'!$I$17+'MAR 20-APR 2'!$P$!$I$17
Here is what it is being changed to
=+'MAR 20-APR 2'!$I$17+'MAR 20-APR 2'!$P$17+'MAR 20-APR 2'!$Q$17+'MAR
20-APR
2'!$S$17
now here is the braek down of the formula - the 'MAR 20-APR 2' refers to
the
page where the information is, the !$I$ refers to the column and the 17
refers to the line. This is repeted 10 times on a different.

Now how do we get this new formula to copy 10 times per sheet on 26 sheets
in a workbook and change to what each sheet needed from it corresponding
page
automaticly. This is something that I was able to do with excel 97. Ok
smart
one do you have an answer? I would like to know how to do this. Besides
everyone probly understood,but didn't know any more how to do it then I
do.
So be a little more respectful next time to everybody.

"Peo Sjoblom" wrote:

The reason you haven't gotten answer is probably that nobody understands
what
you mean. You might want to post back and make it more understandable


Regards,

Peo Sjoblom

"QuietRanger" wrote:

I'm working on a time sheet and work projection work book and need to
know
how to get it to update the formula for each cell and page. the formula
for
each cell pulls information from 4 different cells of one line on the
time
sheet portion for one day and adds them toghter to give the amount of
hours
the employee is projecting for that day. So how do I set Excel to take
this
formula and change it for the next cell of the projection sheet???
--
QuietRanger