+ Reply to Thread
Results 1 to 2 of 2

Change hyperlink automatically according to the cell

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Greece
    MS-Off Ver
    Excel 2016
    Posts
    18

    Change hyperlink automatically according to the cell

    i will explain what i need to be done i have in different cells the code of some projects. These projects have a specific url please see bellow
    20484
    20479
    20478
    20477
    20476
    20475
    20474
    20473
    20472

    the url for all these is the same with the only difference the number in the end like:

    https://services.anavasis.gr/Adminis...say/Edit/20484

    i need to make all projects have that hyperlink but changed with the identical number. So all above should be linkable and sending to each project every time.

    Thank for answering.
    Moreover after having the links done how is it possible to multiple open then in firefox?

  2. #2
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    438

    Re: Change hyperlink automatically according to the cell

    Assuming your project codes are located in range A2:A??, try running the following VBA code:
    Please Login or Register  to view this content.
    Alternatively, you can place the following formula in cell B2 and drag-copy it down as needed:

    =HYPERLINK("https://services.anavasis.gr/Administration/Essay/Edit/"&A2,A2)
    Last edited by Root_; 09-24-2017 at 02:52 PM.

+ 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. [SOLVED] Hyperlink Formula Cell reference change Automatically
    By disepyon in forum Excel General
    Replies: 10
    Last Post: 07-23-2017, 05:58 AM
  2. [SOLVED] How to automatically add a hyperlink to the corresponding Cell no.
    By ALLANT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2016, 06:26 AM
  3. [SOLVED] automatically change colour of hyperlink when click
    By ROHITPRAJAPATI in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2015, 05:50 AM
  4. automatically change text in automated e-mail from hyperlink
    By worldwebber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-21-2014, 09:11 PM
  5. How to automatically copy cell with hyperlink from one sheet to the other
    By shalhevet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 05:48 PM
  6. automatically assign a hyperlink to a cell
    By Brad J. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2006, 08:25 AM
  7. Convert Hyperlink to cell value automatically
    By Convert Hyperlinks in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2006, 05:55 PM

Tags for this Thread

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