I have several Formula and Function Category Worksheets that have specific formula names for each. There is a seperate worksheet for each category with their specific formula/function names in one or more columns. How can I select those Formula / Function Names and have it automatically add a hyperlink to its specific worksheet, located within the same workbook. The Formula/Function Name, is identical on both worksheets. The target worksheet has the name on both the Worksheet Tab and cell A1 if that makes any difference.
I actually did this manually, but when copying some of those to another worksheet, some of the hyperlinks did not transfer properly, while some did, don't know why. So, now I want to automate the process.