I have a spreadsheet which contains multiple hyperlinks in column B that are linked to various worksheets in the same workbook. For some reason, the links are changing to the wrong worksheets constantly and require manual editing.
All of text in column B matches the name of a worksheet. For example, in cell B2 the hyperlink text is RIA0000 and there is a worksheet also named RIA0000 that its suppose to link to.
Is it possible to run a macro that will look at each cell in column B (starting at B2), and if there is a hyperlink, automatically update it so that the page source matches the name in the cell? Looking at the previous example, the text in cell B2 is a hyperlink named RIA0000 but due to this issue the hyperlink is going to an incorrect worksheet. Can the macro look at cell B2, see that its named RIA0000 and then change the link source so that when clicked it will take the user to worksheet RIA0000?
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
Thank you