Extract a List of Worksheet Names Using Functions - With 2 ways Navigation

[@SuperOnur1987]

I have 4 different solutions for the quiz question: 1) By using the same index function we created with the same defined name; =COUNTA(INDEX(MySheets,0)) 2) We can define a new name via name manager similar to before. Let's call it as "CountSheets" coming with formula Get.Workbook(4) =INDEX(CountSheets,0) 3) Select any cell you want, type "=CountSheets" formula and then hit Enter =) 4) The formula below also gives the count of total number of sheets in the workbook as well; =Sheets() By the way, your whole tutorials are really great and I'm grateful for that. Thank you very much ;-)

[@erikguzik8204]

Awesome video. VERY well explained. I know this video is a few years old, just some update info for any Office 356 Users , here is how you can make the list that was created in Col(A) instead of manually copying the formula. It will also always show the number of sheet names you have. =TEXTAFTER(INDEX(MySheets,SEQUENCE(SHEETS())),"]")

[@mohammadmohammad-yv4md]

When Nabeel explains the thing, it becomes easier either of all the ways!!! Commendable 👏👏👏

[@lonniepeterson9878]

Exceptionally useful for large spreadsheets with multiple worksheets. I have a very large Budget spreadsheet for our businesses and have been forever clicking back and forth between worksheets... this is so useful in saving time. Thanks for providing this.

[@Officeinstructor]

I invite you to watch the other methods as well. (links below the video)

[@educacionportable]

Wow beautiful way to teach! Thank u so much master for share your knowledge. God bless u more!

[@Officeinstructor]

You are very welcome

[@1gopalakrishnarao]

Excellent. Very informative. Interesting, inspiring, revealing, thought provoking, realstic, lucid & candid..Thanks a lot.

[@Officeinstructor]

Glad you like it. I invite you to Watch my new tutorials

[@lawrindaquaye7354]

wow! Good teacher, this has really help me. Thank you very much

[@iankr]

Very clear and concise explanation. Many thanks!

[@stevew3384]

Wonderfully put across: that was the best 15.43 minutes I have spent on KZbin. I am new to your channel and I am grateful for clear, step by step explanations. Thank you.

[@Officeinstructor]

What a coincidence, I'm online and I read your comment almost in real time... There are lots of amazing videos on my channel... I will be glad to have you as a subscriber... The Best Is Yet To Come

[@shaniwafa]

Mr. Nabil, It is very nice to see your videos. I used to watch your all available updates. I like your way of presentation of the subject and specially your accent. Thanks for your all endeavors for educating one who loves the excel. Great job Shaniwafs

[@Officeinstructor]

Many many thanks

[@nooramin5386]

Its just amazing my friend, I am speechless. Thanks a lot

[@bsdardi]

Your excel knowledge is amazing....

[@Officeinstructor]

Thanks a ton

[@abdullavazhayil4868]

Very good description ♥️🖤💜💜

[@mohitjagad]

Superb.. Much informative & useful.. Thanks for sharing.

[@Officeinstructor]

My pleasure 😊

[@Luciano_mp]

Awesome, very cool, very useful. Thank you!

[@zaighamuddinfarooqui1705]

Awesome. In my opinion PQ's method is best.

[@Officeinstructor]

I agree

[@nadermounir8228]

Very nice video. Thank you for your hard work 👍

[@ohdjrp4]

This is great! Thanks!

[@Moogie3131]

OUTSTANDING

[@Officeinstructor]

Thank you

[@fabricegemo9443]

Very helpful. Thanks a lot. One request though. What do I have to do in order to have the list dynamically, in the sense that any new sheet tab that appears afterwards, the List of Sheets to update automatically?!

[@vitarathiel]

cool tutorial ! how to make the list sheets horizontaly ?

[@majidsiddique8227]

Very informative

[@Officeinstructor]

Glad it was helpful!

[@hssmalaysia]

You're the best. Subscribed!

[@Officeinstructor]

Thank you for the nice comment. Show your support to my channel by sharing the video

[@brainamplifier]

what if i have more than 38 worksheets .. how to fetch the names then? btw you are an amazing teacher

[@satchuarchary8186]

Awesome !!!!!!!!! Thank You for these tips. Also wanted to know whether you can also add a column to show the status of the sheet eg; Visible or Hidden Thank you once again

[@Officeinstructor]

I might answer your question in a future tutorial... Stay tuned.... The Best Is Yet To Come

[@satchuarchary8186]

@@Officeinstructor Thank You Really appreciated the feedback

[@koolgk]

This is just amazing. Is there a way to exclude hidden slides

[@zbigniewkowalczyk1]

thanks for that. followed steps I managed to create links between different worksheets. but cant get automatic update to the list when I ad new worksheet or I change name of old ones. did I miss anything ? thanks

[@swee8181]

Love

[@taufiquealam3153]

Thanks for the video. It helped me a lot. But how can i get a cell value(say H8) from a sheet after getting the sheet name using this formula? Waiting for your valuable answer.

[@azherrafiq6539]

i want to create main worksheet with specific data and dates i.e court cause list. dates are changed/adjourned dates as required .if next date is added or change it may create automatic cause list on worksheet as per date ...and it collect data from main worksheet as per date entry. .your reply will be appreciated . thanks

[@avanishchandra3795]

Wow

[@rasoulkhoshravan5912]

I have a list of names in one sheet. I want to produce sheets that get the name from that list. How can I do that?

[@abdullahazrezar8005]

You just need to Click right Click between the arrows in the corner of workbook beside of sheet bar

[@Officeinstructor]

Thank you Abdullah... I already mentioned this option in my tutorials, but the purpose is to create a Table of Contents which you could then use in your project (not just see them) like use sheet names in other formulas or even print them or export for collaborative working ...beside we created Both ways navigation.