Copying Links to Another File

[Tom]

Need help on how to copy linked cells into another file and keep the
links. I have several files which have links in them, need to combine
all into one file so we can autofilter through all entries. When I
copy over the data and paste, the link does not come with it. Tried
paste all and still does not work.

Any ideas?

 

[Leo Rod]

If the text on the cells are the same as the link location (AKA URL address)
use the function:
'Hyperlink' it turns general text from a cell into a hyperlink, if the
addreses are good it will become a valid link, once you're finished with all
the links, copy and paste "all" over that same set of cells and the formula
will be removed leaving only hyperlinks.

If you have "friendly names" and not valid URL with hyperlinks on it, we
should use a different approach.

Let the group know to see what solutions we can come up with.

Greetings

Leo Rod
MIA, FL.

 

[Tom]

If the text on the cells are the same as the link location (AKA URL address)
use the function:
'Hyperlink' it turns general text from a cell into a hyperlink, if the
addreses are good it will become a valid link, once you're finished with all
the links, copy and paste "all" over that same set of cells and the formula
will be removed leaving only hyperlinks.

If you have "friendly names" and not valid URL with hyperlinks on it, we
should use a different approach.

Let the group know to see what solutions we can come up with.

Greetings

Leo Rod
MIA, FL.

That didn't work, but found something that did, though dose not make
sense. If I save "as is" in the folder above the existing links it
works. So I have to "save as" the original file to the folder which
has the other files I want to copy into, then I can copy the cells and
paste into my original file, then "save as' to the location of the
next file that has the files I want to copy the links, and so on.

Tom