Link to home
Start Free TrialLog in
Avatar of Element_Can
Element_CanFlag for Canada

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
ASKER CERTIFIED SOLUTION
Avatar of Krys_K
Krys_K
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial