Forum Discussion
Including hyperlinks when linking cells in different sheets
Hello! So, I have a file with several sheets - the first is a master list of cells linking to external resources, while the other sheets are divided by topic. Each cell in the master list sheet conta...
Excel doesn't natively support linking both the text and its associated hyperlink directly from one worksheet to another using formulas. However, you can write a simple VBA macro that will automatically copy both the cell text and the hyperlink each time you update your master list.