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?
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
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 !
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
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
Thank you so much for walking through this step by step - excellent training!
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.
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!
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?
Excellent information formula. Thank you very much Chester.
thank for your sharing
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.
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
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 !
How would I return the name of the "XYZ LTD" sheet on the "ABC LTD" sheet?
good question
i figured it out it think
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
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?
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