| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying and auto updating a formula
I have a column AB (accum hours) on sheet I and it calculates a sum for the previous 8 weeks (ie sheets A to H) which works fine, but when we copy the formula on to the next week (sheet J) it stays the same when we need it to calculate sheets B to I, and so on for the rest of the year, any ideas? i know its probably simple |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Updating | Excel Worksheet Functions | |||
| auto updating list | Excel Worksheet Functions | |||
| Cell formula not updating, auto calc on, over 100 sheets | Excel Discussion (Misc queries) | |||
| Auto Updating Formula | Excel Discussion (Misc queries) | |||
| How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions | |||
Threaded Mode
