MassSpecGuru
Board Regular
- Joined
- Feb 23, 2010
- Messages
- 55
I have a workbook with 21 worksheets in it. The first worksheet is titled "Summary" and the rest are just the default name(s): Sheet1, Sheet2, ...
In the Summary sheet I want to write formulas that reference data in the other 20 sheets. Since there will be hundreds of formulas, I want to try and develop a method for referencing the various sheets easily, in a manner that will work when copying and pasting or filling right or left, etc.
To that end, I wanted to try using a formula such as:
=SheetRow()!$A$1 in the first row of the Summary sheet instead of
=Sheet1!$A$1
but it doesn't work.
Can this be done within cells (i.e. with Excel functions, not VBA code), and if so, how?
Thanks in advance for your assistance.
In the Summary sheet I want to write formulas that reference data in the other 20 sheets. Since there will be hundreds of formulas, I want to try and develop a method for referencing the various sheets easily, in a manner that will work when copying and pasting or filling right or left, etc.
To that end, I wanted to try using a formula such as:
=SheetRow()!$A$1 in the first row of the Summary sheet instead of
=Sheet1!$A$1
but it doesn't work.
Can this be done within cells (i.e. with Excel functions, not VBA code), and if so, how?
Thanks in advance for your assistance.
