Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
autom update cells from Workbook1 to Workbook2 | Excel Discussion (Misc queries) | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) |