Hi,
I am writing a macro for work and I cannot seem to move a hyperlink. Here is the situation.
We have one sheet that is full of data (on a tab labeled Data). In the same workbook we have one row of the data formatted into a cover sheet. Some of the cells in the data sheet contain hyperlinks to pdf files (charts and graphs). I wrote a macro to move the data in the row of my choice to the correct cell in the cover sheet, but the hyperlinks don't transfer, only the words do. Does anyone know how to move the actual hyperlink to a different cell while keeping the text that calls the hyperlink the same. For instance if I have the word CHART linked to a chart in the data sheet, I want to put the word CHART in a specific cell on the cover sheet and still have it link to the correct chart. Thanks for the help.