May 28th, 2010, 01:36 PM #1
Microsoft Excel question
I have a workbook that has many worksheets (Sheet1, Sheet2, etc.,)
Let's say on Sheet1 I want to reference values on the other sheets (Sheet2, Sheet3, etc.,), but I want to quickly change which sheets those are (i.e., sometimes I want to be referencing Sheets 3 to 5, another time I want to point to Sheets 9 to 11).
So, whereas normally in the formula for a cell in Sheet1 I would write a absolute reference like this:
.... what I want now is to replace the hardcoded string "Sheet2" with some kind of reference to another cell on Sheet1 that will contain a formula that I can easily change to different Sheet #'s as needed.
May 28th, 2010, 02:16 PM #2
So what if you just had a sheet that was all the formulas you want to update?
so in =Sheet1!a1 you had =Sheet2!B2
perhaps im not understanding you but i think that should work?