+ Reply to Thread
Results 1 to 2 of 2

add hyperlink after suffixing a unique value in the URL through macro.

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    48

    add hyperlink after suffixing a unique value in the URL through macro.

    There is a column whose values should be suffixed with a common URL and add hyperlink to it. Can some one help in getting this through macro?

    Sample sheet attached;

    1st sheet has the original raw table.

    2nd sheet has the table which I need as a output.

    Thanks in advance.add url.xlsx

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: add hyperlink after suffixing a unique value in the URL through macro.

    Hi there,

    Take a look at the attached workbook and see if it does what you need.

    The attached version will create the Hyperlinks in Columns "E" and "F" (i.e. beside the existing "data" cells). If you want to overwrite the "data" cell with the corresponding Hyperlink you should replace the values of "F" and "E" in the following code with values of "D" and "C" respectively:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlink mapping of unique values from one sheet to another
    By jcardi2890 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2013, 05:01 AM
  2. Replies: 0
    Last Post: 10-16-2013, 02:07 PM
  3. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  4. hyperlink (to a unique key
    By johnny1 in forum Excel General
    Replies: 0
    Last Post: 07-22-2010, 02:41 PM
  5. [SOLVED] Intra-workbook hyperlink: macro/function to return to hyperlink ce
    By marika1981 in forum Excel General
    Replies: 3
    Last Post: 05-06-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1