hello,
please help. I've done this before a long time ago and I completely forget how I did it!
I have a calculation template that is the same for 10 different sheets. Just what I am calculating/the outcome changes per each sheet.
What I'm doing is setting up a summary sheet and instead of going through all of them and referencing each sheet/cell a million times, I just want to basically reference one cell in the summary worksheet that I type in the tab name and put the cell.
In other words, on sheet1, sheet2 and sheet3 I want to reference cell A3. So what I want to do is on the Summary tab, have reference cell, we'll say B2 and put in a 'Summary' tab cell something like:
="'"&B2&"!'"&A3
and in cell B2 put in Sheet1 or Sheet2 etc.
Thanks!!
Bookmarks