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.