Seems simple but I can't get it to work. I have a variety of similar summary data I am doing across various data sets that needs to remain seperate. The formulars are extremely complex and based on pivot tables in which I have various dynamic name ranges set up in. When I go to recreate the summary for another group of data I have to go into each set of complex calculations and change the name ranges its referencing.
Is there a way to just reference a cell in this case instead of inputting the name of the range 20 X and put the single name range in that cell. That way when I go to duplicate it on other data I can just type the new name range in the cell.
To simplify;
Data Range: Data1
Forumla: Max(Data1)
Later I need to use the same Formula but need it for Data2. Instead of having to go and change Data1 to Data2, can I do something like.
Have Cell C1 = "Data1"
Forumla: Max(C1) or Max(Indirect(C1))
then when I duplicate this for other areas I can just change the value in C1 instead of in my formula?
Is there a way to just reference a cell in this case instead of inputting the name of the range 20 X and put the single name range in that cell. That way when I go to duplicate it on other data I can just type the new name range in the cell.
To simplify;
Data Range: Data1
Forumla: Max(Data1)
Later I need to use the same Formula but need it for Data2. Instead of having to go and change Data1 to Data2, can I do something like.
Have Cell C1 = "Data1"
Forumla: Max(C1) or Max(Indirect(C1))
then when I duplicate this for other areas I can just change the value in C1 instead of in my formula?