• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

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
0
Element_Can
Asked:
Element_Can
1 Solution
 
Krys_KCommented:
Hi there
I have sent back the worksheet you provided with a macro to do what i think it is you wanted. Let me know if this is ok
Regards
Krystian

Hyperlink-Text.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now