If you want to follow along with this video, you can access the worksheet I created in this video as an example for free. No need to share your email to access this file: drive.google.com/drive/folders/1tZsrkCtdUHkvFZ5vfYpoBFTPefY1F-sZ?usp=sharing Thanks for watching!
Sharon, this is one of my favorite Excel "how-to" videos. I found this easy to follow, with a good pace and examples. I was able to implement it on one of my more important worksheets, so excited to add this to my list of skills!!!
Hello Sharon! Your Excel videos are very helpful! I use Excel to manage my invoices that I send to clients. I keep a summary page where I put the job name, date, and total amount charged from each invoice. Is there an easy way to pull this data from all my sheets? I work in the same document and create a new tab for each invoice. As of now I'm doing it all manually and it's a bit of a pain.
Super helpful. Also I wanna filter hyperlinks from another table because when I am using filter function only the names are shown, not the links. I have tried so many things but it’s not working and I have to see the filter result and go back to the table to find out the hyperlink. Please help.
Perhaps it's my relative newness to digging into these sort of topics in Excel or my lack of understanding how Onedrive works, but can you say a little more as to why one has to pause OneDrive auto-synch and turn off auto save to perform this function? Thanks...
Thank you for your question! If you have a large number of sheets (like 500), manually adding a hyperlink to each sheet would be very time-consuming. However, you can automate the process using a simple VBA macro to add the link to every sheet in your workbook. Here’s a basic macro that can help: Press Alt + F11 to open the VBA Editor. In the editor, go to Insert > Module to insert a new module. Paste the following code into the module: Sub AddHyperlinkToTOC() Dim ws As Worksheet Dim TOCSheet As String TOCSheet = "MasterSheet" ' Replace with the actual name of your TOC sheet For Each ws In ThisWorkbook.Worksheets If ws.Name TOCSheet Then ws.Hyperlinks.Add Anchor:=ws.Range("A1"), Address:="", SubAddress:= _ "'" & TOCSheet & "'!A1", TextToDisplay:="Go to TOC" End If Next ws End Sub Replace "MasterSheet" with the exact name of your TOC page. Press F5 to run the macro. This macro will add a hyperlink labeled “Go to TOC” in cell A1 of every sheet, except for the TOC sheet itself. If you need the link in a different location, you can change the cell reference in the code (e.g., change ws.Range("A1") to another cell). I hope this helps! Thanks for watching!
Hello can you tell me how i can make a table of contents for only 1 tab in exel? So the table needs to refer to the start of a chapter on a row. Depending on adding new information the location of the row can/will change regularly.
If you want to follow along with this video, you can access the worksheet I created in this video as an example for free. No need to share your email to access this file: drive.google.com/drive/folders/1tZsrkCtdUHkvFZ5vfYpoBFTPefY1F-sZ?usp=sharing Thanks for watching!
Sharon, this is one of my favorite Excel "how-to" videos. I found this easy to follow, with a good pace and examples. I was able to implement it on one of my more important worksheets, so excited to add this to my list of skills!!!
I’m so glad to hear that! Thanks so much for taking time to leave a nice comment, I really appreciate it! Thanks for watching!
I always download your videos to improve my work.
That is great to hear! Thanks for supporting my Channel!
Super helpful Sharon!! Thank you so much for this video.
Glad to help! Thanks for watching!
Thank you so much!❤
Thanks for watching!
Hi Sharon, Your video is very helpful to my work
I'm so glad to hear that! Thank you for watching my videos!
I absolutely love your videos🙏🏽
I'm so glad you find my videos helpful! Thanks for watching!
Hello Sharon! Your Excel videos are very helpful! I use Excel to manage my invoices that I send to clients. I keep a summary page where I put the job name, date, and total amount charged from each invoice. Is there an easy way to pull this data from all my sheets? I work in the same document and create a new tab for each invoice. As of now I'm doing it all manually and it's a bit of a pain.
Super helpful. Also I wanna filter hyperlinks from another table because when I am using filter function only the names are shown, not the links. I have tried so many things but it’s not working and I have to see the filter result and go back to the table to find out the hyperlink. Please help.
Perhaps it's my relative newness to digging into these sort of topics in Excel or my lack of understanding how Onedrive works, but can you say a little more as to why one has to pause OneDrive auto-synch and turn off auto save to perform this function? Thanks...
Any way to mass add the link to the TOC page? What if I have 500 sheets for example, how do I add a link to all of them?
Thank you for your question! If you have a large number of sheets (like 500), manually adding a hyperlink to each sheet would be very time-consuming. However, you can automate the process using a simple VBA macro to add the link to every sheet in your workbook.
Here’s a basic macro that can help:
Press Alt + F11 to open the VBA Editor.
In the editor, go to Insert > Module to insert a new module.
Paste the following code into the module:
Sub AddHyperlinkToTOC()
Dim ws As Worksheet
Dim TOCSheet As String
TOCSheet = "MasterSheet" ' Replace with the actual name of your TOC sheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name TOCSheet Then
ws.Hyperlinks.Add Anchor:=ws.Range("A1"), Address:="", SubAddress:= _
"'" & TOCSheet & "'!A1", TextToDisplay:="Go to TOC"
End If
Next ws
End Sub
Replace "MasterSheet" with the exact name of your TOC page.
Press F5 to run the macro.
This macro will add a hyperlink labeled “Go to TOC” in cell A1 of every sheet, except for the TOC sheet itself. If you need the link in a different location, you can change the cell reference in the code (e.g., change ws.Range("A1") to another cell).
I hope this helps! Thanks for watching!
Nice 👏🏾👏🏾👏🏾
Glad you found it helpful! Thanks for watching!
Hello can you tell me how i can make a table of contents for only 1 tab in exel? So the table needs to refer to the start of a chapter on a row. Depending on adding new information the location of the row can/will change regularly.
Nice
Thanks so much for watching!
Hello how are you Sharron good evening I just want to tell u today I hv achieved 10 years long service award.
Congratulations! I'm so happy for you. 🙌 Thanks for watching my videos!