Copy hyperlinks

[scorziello]

On Sheet2 in Column G I have links that are imported via a web connection. I would like to be able to copy specific ones, based on an index match, to Sheet3 to column E starting in row 2 which is the first row of a table. I know how to do an index match but it doesn't keep the external hyperlink intact. I think a macro is the only way accomplish this but I have no idea where to start with something like this.

 

[VincentNL99]

How I would do it I would need to know the criteria of your index

 

[VincentNL99]

Actually I don't I guess. You just want the cells from column E to also contain the hyperlink of the cell it refers to right?

 

[scorziello]

Not sure if I understand you or not. Basically I want to copy the web addresses (ex. www.abc.efd/12ab34, they will all be unique), as hyperlinks, in Sheet 2 column G and move it to Sheet 3 Column E. Everything I have tried so far only copies the text value and does not retain hyperlink.

 

[VincentNL99]

Not sure if I understand you or not. Basically I want to copy the web addresses (ex. www.abc.efd/12ab34, they will all be unique), as hyperlinks, in Sheet 2 column G and move it to Sheet 3 Column E. Everything I have tried so far only copies the text value and does not retain hyperlink.

Hey,

I see, the output of an index match doesn't retain the hyperlink. I'll get back to you with a code

 

[VincentNL99]

How does this function not meet your request?

=HYPERLINK(INDEX(Reference, row, column))

 

[scorziello]

I had actually tried

=HYPERLINK(INDEX(Reference, row, column))

with no success. This does create a hyperlink but it does not keep the link to the actual webpage intact.

I ended up using

Sheets("Sheet1").Range("A1:A25").Copy
Sheets("Sheet2").Range("F2").PasteSpecial Paste:=xlPasteAllUsingSourceTheme