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 ?
|