Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy hyperlinks
Hi
I have a sheet containing 2-300 hyperlinks to webpages in a row. The row to the left of the row with hyperlinks contains an ID for each link. This is a nice table, and I thought it would be a simple task to use VLOOKUP to put the hyperlinks in to another table that uses the same ID as in the first table with hyperlink. To give you an idea of what I mean, please look at the example tables below: Table 1 Table 2 ID1 Hyperlink1 ID3 ID2 Hyperlink2 ID1 ID3 Hyperlink3 ID5 .. .. .. IDn Hyperlinkn Table 2 should then use VLOOKUP to fetch the hyperlinks from Table 1. The problem is that VLOOKUP does not put in the links as links, only the text that the links show. Example: Lets say a hyperlink shows the text "New York Times", and by clicking on the link it takes you to www.nytimes.com. VLOOKUP then simply puts the text "New York Times in the cell where VLOOKUP is. Same thing happens when using Copy and Paste from Visual Basic. However, doing a manual Copy and Paste in the sheet actually copies the links as links. So if someone knows a way to copy/lookup the links, that actually results in clickable links at the destination, I will be gratefull. Thanks a lot for any help! -- Jesper Kaas - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste the hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Copy HYPERLINKS | New Users to Excel | |||
Copy/Paste using hyperlinks | Excel Programming | |||
how do you copy hyperlinks from one worksheet to another | Excel Worksheet Functions |