Your tutorial is wonderful and straightforward. thank you! However, I am now having each sheet reference to the other sheet name, not the sheet name I am on without resetting formula. Is there a fix for this?
What about pulling the sheet name into a cell from a different tab/sheet? So I have a primary sheet where I'm consolidating all the sheet names in the same workbook
Hi, thanks for your video. I was wondering if you have any idea how to do the following : I would like to return in a cell from the Tab 1 the second tab name. In your case for example in A1 (tab ABC LTD) I would like the cell to return the second tab name here : XYZ LTD. I can't find any solution online. Thank you !
Hey Chester, the function works well but when you have multiple tabs or sheets open the formula reflects the result where the cursor is, any trick to lock the formula for a each separate tab? Appreciate the help
This used to work for me but now it is returning the whole file name and not picking up just the sheet name after the ]. I'm not aware I changed anything
![Tee Grizzley - Blow for Blow (feat. J. Cole) [Official Video]](http://i.ytimg.com/vi/wNLN5xsx5dc/mqdefault.jpg)
How do I get it to just work per sheet? Right now when I do that to a bunch of sheets they all return the same value.
thank for your sharing
How would I return the name of the "XYZ LTD" sheet on the "ABC LTD" sheet?
good question
i figured it out it think
THIS IS GOOD IF I HAVE JUST ONE SHEET. FOR MULTILE SHEETS IT FILLS IN THE VALUE OF THE SHEET I JUST LOOKED UP ON ALL THE SHEETS. ADVICE?
Your tutorial is wonderful and straightforward. thank you! However, I am now having each sheet reference to the other sheet name, not the sheet name I am on without resetting formula. Is there a fix for this?
What about pulling the sheet name into a cell from a different tab/sheet? So I have a primary sheet where I'm consolidating all the sheet names in the same workbook
Hi, thanks for your video.
I was wondering if you have any idea how to do the following :
I would like to return in a cell from the Tab 1 the second tab name.
In your case for example in A1 (tab ABC LTD) I would like the cell to return the second tab name here : XYZ LTD.
I can't find any solution online.
Thank you !
Thank you so much for walking through this step by step - excellent training!
Is there a way to do this in the online version of Excel? Just gives me an error if I don't use the desktop version.
Excellent information formula. Thank you very much Chester.
man ! you just saved me hours of work, i have been researching like 40 min, something about indirect function, this is way clever!
Glad it helped!
great help Chester, subscribed:)
Hey Chester, the function works well but when you have multiple tabs or sheets open the formula reflects the result where the cursor is, any trick to lock the formula for a each separate tab? Appreciate the help
This used to work for me but now it is returning the whole file name and not picking up just the sheet name after the ]. I'm not aware I changed anything