How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links

How to automatically generate multiple sheet tabs in your Excel workbook based on an existing list of values. Create sheet tabs from your list then make a table of contents tab with hyperlinks to all the other tabs. Generate your tabs automatically without having to manually type them out and without VBA. Use this Pivot Table trick to save time and auto create multiple sheet tabs from your list of values. Then create a master sheet table of contents in Excel that has hyperlinks to all the sheet tabs in your workbook.

Hyperlink formula used in this video (replace "Index" with your own sheet name):
=HYPERLINK("#'"&[@Index]&"'!A1",[@Index])

TIMESTAMPS ⏰
00:00 Create Sheet Tabs from a List
00:13 Generate Sheet Tabs from Pivot Table
03:29 Create Table of Contents with Hyperlinks

COURSE 🎒
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https://www.youtube.com/playlist?list=PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs

WATCH NEXT 📺 Create Master Sheet Table of Contents by Generating a List from Multiple Sheet Tabs: https://youtu.be/1ZBfu8geIK0

CHANNEL LINK 📺
https://www.youtube.com/@SharonSmith
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!

TEMPLATES 📄
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel! 🌟

FREE DOWNLOADS ⬇️
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.

CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearning/
Facebook: https://www.facebook.com/SharonSmithLearning

GEAR ⚙️
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)

RESOURCES 📚
✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL 🙌
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️

PLAYLISTS 🎥
➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

➤Create A Letterhead in Word: https://www.youtube.com/playlist?list=PLb80efKTbWuO0RyeiYB0fEb55601yL4OT

➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

➤PowerPoint Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

KEYWORDS: @SharonSmith

Видео How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links канала Sharon Smith