Hello -
Here is a formula which returns the value from another sheet found at the intersection of a column range (d12.31.12, which is a date) and a row range (Room250, which is a location).
=(INDEX(d12.31.12,ROW(Room250),))
I have 52 similarly named columns (one for each week) and a dozen or so named rows (one for each location). That formula is copied many times in a different sheet to return all the values for all the rooms for all the weeks. I had planned to use Find/Replace to update the named ranges as needed to advance the date and/or room. I quickly figured out that while Find/Replace will update the text in my formulas, the replaced text wont function as a named range. So, I am left with doing it manually or using F3, which will take forever given the number of formulas I have to deal with.
Any help which will let me find and replace all the d12.31.12 named ranges in the formulas a given selection of cells with another named rage, d01.06.13, for example? I cant simply change the name of the range, as it is still applicalbe to a difference range of cells.
Am I making any sense?
Here is a formula which returns the value from another sheet found at the intersection of a column range (d12.31.12, which is a date) and a row range (Room250, which is a location).
=(INDEX(d12.31.12,ROW(Room250),))
I have 52 similarly named columns (one for each week) and a dozen or so named rows (one for each location). That formula is copied many times in a different sheet to return all the values for all the rooms for all the weeks. I had planned to use Find/Replace to update the named ranges as needed to advance the date and/or room. I quickly figured out that while Find/Replace will update the text in my formulas, the replaced text wont function as a named range. So, I am left with doing it manually or using F3, which will take forever given the number of formulas I have to deal with.
Any help which will let me find and replace all the d12.31.12 named ranges in the formulas a given selection of cells with another named rage, d01.06.13, for example? I cant simply change the name of the range, as it is still applicalbe to a difference range of cells.
Am I making any sense?
