Summary sheet from tab names

J

Joe F

I have been racking my brain on how to make this work! I have created a
workbook with 70 tabs and a summary sheet linking to specific info on each
worksheet. I would like to be able to change the tab name and have that
change on the summary sheet as well. Is this possible?

Examble tab name is currently generic "Person 1" Summary sheet is also
(manually) entered as "Person 1" I want to be able to rename the tab to Jim
Smith and have that update on the summary sheet as well.

I have not worked with macros

Thanks

Joe
 
G

Gary''s Student

The change should be automatic. Start with a new workbook and in a cell in
Sheet1, enter:

=Sheet2!B6

Then go to Sheet2 and re-name it jim. Then go back to Sheet1 and the
formula will have automatically changed to:

=jim!B6
 
D

Don Guillett

If you are using a macro instead of a formula to populate you will need to
change the name in the macro or refer to the sheet by its index or sheet.

sheets("sheetname")
sheet1
sheets(1)
 
D

Don Guillett

Codename is the one you would want so you can move around and rename

Sub sheetsid()
name
MsgBox Sheets("sheet11").Range("d2")
codename
MsgBox Sheet12.Range("d2")
index
MsgBox Sheets(6).Range("d2")
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top