LinkBack URL
About LinkBacks
Hi
Is there a way to create a table of index of the tabs without using VBA Codes or Power Query etc. in Excel 2021 / Office 365 Please
Sample file attached
Thank you for your help in advance
Hi
Is there a way to create a table of index of the tabs without using VBA Codes or Power Query etc. in Excel 2021 / Office 365 Please
Sample file attached
Thank you for your help in advance
No, that's not possible without VBA or PQ.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
This describes what you are asking for. https://www.howtoexcel.org/how-to-ge...k-without-vba/
You do, however, need to save the file as a macro enabled workbook. Pretty sure the mechanism is using Excel 4 macros so it might not meet the brief.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Create a defined name (I've called it SheetNames) & in the refers to box putAnd then in the sheet you can useFormula:
=TOCOL(TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]"))Assuming you don't want the 1st sheet listed.Formula:=DROP(SheetNames,1)
Thanks Fluff13 this worked fine and appreciate your help
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks