Element_Can
asked on
Looking for method of combining a list of hyperlink locations with the text using a macro or other method
I have two lists. Column A is the destination for the hyperlink or friendly name. Column B is the actualy text locaiton of the hyperlink not yet embeded.
What i need is some method of combining these items in a mass method. A macro would be perfect.
The end result would be a single or 3rd column showing column A with the hyperlink in column B. This could be in the same sheet or a new sheet as long as the resulting column of data can be coppied and embeded in another document.
Hyperlink-Text-1.xls
What i need is some method of combining these items in a mass method. A macro would be perfect.
The end result would be a single or 3rd column showing column A with the hyperlink in column B. This could be in the same sheet or a new sheet as long as the resulting column of data can be coppied and embeded in another document.
Hyperlink-Text-1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.