How do I copy hyperlinks from one excel sheet to another?

Hey all, I’m trying to copy over data from one excel workbook to another, this works easily for the most part except my “Comments” column, which is displaying as a .txt file, but the more important information is the the hyper link

It pastes the data in the other excel workbook, but with no hyper link.

Hi @David_Hernandez2

You are using read range right, open the properties of read range activity, find out the option called Read formatting, select the Raw value option in that dropdown.

Check the below image for better understanding,
image

Hope it helps!!

Hi @David_Hernandez2

How about the following?

Input Excel:

image

Output Excel:

image

Regards,

1 Like

Yes thank you! This is probably the best solution.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.