[Dba-office] Excel sheet tabs & reference to it

Susan Harkins ssharkins at gmail.com
Thu May 10 16:41:13 CDT 2018


Yeah!

Susan H. 


Hi Susan,
Today I open the spreadsheet and things work like I thought they should, e.g. I change a tab name and all references to that tab name in the sheets updated automatically. Last night that didn't seem to work.
John B

-----Original Message-----
From: Dba-office <dba-office-bounces at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: Thursday, May 10, 2018 6:12 AM
To: dba-office at databaseadvisors.com
Subject: Re: [Dba-office] Excel sheet tabs & reference to it

I don't think you can "find and replace" the sheet name, but you could do it programmatically. You kind of lost me though in the totals paragraph. 

Have you considered an info page where you enter the names and then let the sheets reflect what's in the info sheet? Then, you'd need to change only the data on that sheet? 

Am I following you okay -- or have I misunderstood the setup? Back to the sheet names though -- a sheet name can't directly reference cell contents, but I'm sure there's a workaround for that. It sounds like a reasonable thing to do, so I'm betting somebody's already thought of it. 😊 

Susan H. 


I have a baseball roster, player stats and team stats. Each player gets a sheet with all of their stats per game. That sheet has the players name as the sheet tab name.

At the end of each season all I have to do is type in the new player roster and everything works. Except the Tab names and because the sheets are references for the team totals, the tab names are in the totals function's reference.

Is there some method of finding and replacing a word in the entire workbook - including the name of the sheet tabs?

Or is there a method to reference the tab without using the tab's name?

Thanks,
John B

_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office


_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office

_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office




More information about the Dba-office mailing list