Jan 28 2020 11:38 AM
I would like to have my tab in excel show up on a title inside the Excel page
Can I refer to it so it automatically shows when I create the tab.?
Jan 28 2020 11:58 AM
Jan 28 2020 12:31 PM
No it is actually for the purpose of Identifying the Worksheets for my R & D so that my worksheets carry the same title as the project and therefor the tabs.
I usually have 8 to 16 different tabs , So I only want to write the title name once ..either in the spreadsheet or on the TAB .
THanks
Jan 28 2020 01:01 PM
Interesting. I'm not able to find a Function that would do this. I did try SHEET and can think of a way you could use that along with VLOOKUP but it would involve more work (and may not be as reliable) as biting the bullet and, you know, writing it twice.
It's entirely possible that there could be a VBA routine developed, but again, it seems to me (and I'm not a VBA person) like using a bazooka to kill a mosquito.
Let's see what others can come up with.
Jan 28 2020 01:32 PM
Jan 28 2020 01:55 PM
Jan 28 2020 09:28 PM
THanks very much- This makes my day..truly.
I will post another question sometime in the coming month-regarding keeping track of the date I added a new worksheet to my excel file- so that I can keep track of when I created each New project.
Have a great rest of week...
Sep 20 2020 01:19 PM
@Patrick2788 This formula inserts the ACTIVE sheet name. So if I have sheets "List1" and "List2" and I type that formula into cell C17 in "List1" it will return List1. But if I go to sheet "List2" and do some work, it changes cell C17 in "List1" to List2, because "List2" is now the Active Sheet. I have 10 sheets and I put that formula in each one of them - and each one changes whenever I go to any of the other sheets and do anything that makes the worksheet recalculate. So if I have "List 1" "List2" "List3" etc. up to "List10" and have that formula in cell C17 of each sheet, they ALL show the name of the Active Sheet. So for example, if I go to "List5" and add a formula in cell D53, then C17 in ALL TEN of the sheets change to List5.
I want a LIST of all 10 of the sheet names on another of my sheets, (which will reference to the sheet name in each of the "List" sheets) but if I do some work in "List4" then my list becomes:
List4
List4
List4
etc. - instead of what I want, which is:
List1
List2
List3
etc.
I need something that keeps the sheet name for THAT sheet, not the sheet name for the Active Sheet. And I need my list to change when I change any of the sheet names.
Any ideas?
Thanks!
Sep 21 2020 03:40 AM
Please add the reference on any cell in formula, like
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,40)
Sep 21 2020 05:54 AM
@Sergei Baklan - EXCELLENT!! This is the final fix that I needed. Thanks so much!