List of All Worksheet Names in same workbook
Hello,
I am trying to list all worksheet names in the same workbook using the "=INDEX(ListSheets,B3)" formula.
It does work, but I would like to have a list of OLD to NEW (date) orders.
For example:
In column C, list name would start from right to left : "Total", "Oct 16-Oct 21", "Oct 22-Nov 04" & "Nov 5-Nov 18"
Please see attached file CASH_test1.xlsx for your reference.
Could anyone be so kind to help me out.
Thank You
Are you still using Excel 2019?
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.
Sorry, profile updated.
I recently updated to Office 365
Try this:
=LET(l,TRANSPOSE(ListSheets),s,TEXTBEFORE(l,"-"),f,TEXTAFTER(l,"-"),ss,SORT(DATE(2023,TEXT(s,"m"),TEXT(s,"y"))),sf,SORT(DATE(2023,TEXT(f,"m"),TEXT(f,"y"))),t,IFERROR(TEXT(ss,"mmm dd")&"-"&TEXT(sf,"mmm dd"),l),t)
Thank you for your reply, @AliGW.
It did not work when I added new dated tabs to the worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks