Help with Excel formula/Sheet name

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.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,226,730
Messages
6,192,698
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top