| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically update excel worksheet formula
What is the formula or instruction that allows summary data from
Worksheet1:Worksheet? to automatically update when a new worksheet is added. Example: the Summary sheet has the following formula =Min(Worksheet1:Worksheet5!C51), then another worksheet is inserted (Worksheet6). Is there a way to have Excel automatically update that formula to become =Min(Worksheet1:Worksheet6!C51)? Would you do that with a Macro and how could this be accomplished ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
| How do I automatically update my accountability worksheet from my | Excel Worksheet Functions | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Can I update a worksheet automatically while it's open elswhere? | Excel Discussion (Misc queries) | |||
Threaded Mode
