Quickly Referencing Sheet Name

[RSteph]

I’m creating an excel file that has several sheets of site specific information, and then references the information in all of the sheets on a master ranking sheet. There are pretty long formulas involved and there will be upwards of 200 tabs, so I want to write a command that will reference each sheet for the formulas in the rows by text in a single cell, so that the user won’t have to rewrite all the formulas specific to each tab. I’ve attached a picture to help explain. Any suggestions for a command I could use to fill in the sheet name?

Excel Help.png

Excel Help-2.png

[6StringJazzer]

First, an image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

You want to replace this in your formula (no need for it be in parentheses, BTW)

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

However, note that the reference to G7 becomes hard-coded and will not update if a row or column is inserted on sheet 'Street C & Street D' later.

[RSteph]

Thank you so much! This solution worked.