Is it possible to update or refresh an existing formula to reference a named range that was created after the formula.
I am thinking of a simple situation like this:
1. Create formula in Cell A1: =B1+C1
2. Define the name for Cell B1 as "SalesJune"
Now the formula in Cell A1 should read: =SalesJune+C1
Sounds simple doesn't it? I don't know how to do it or if it is possible.
Note that this is 2003 SP2 XP. I have seen solutions in Vista.
Background story is I want a Summary worksheet to reference the 12 monthly worksheets behind it. Note that this is a small amount of data, that is entered in a confusing way for each month, so having a table of data that can then be drawn into a pivot table does not apply.
I intend to create a template worksheet for each month, create the formulae to reference these worksheets quickly while the order (on each of the month worksheets) is preserved. Then name all of the ranges for the cells (from their labels) that feed into the summary page so that the formulae make sense.
Hope that makes sense.