+ Reply to Thread
Results 1 to 3 of 3

How to get Hyperlinks to carry through when using formulas

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    359

    How to get Hyperlinks to carry through when using formulas

    Hi all,

    I have a sheet which uses a large number of basic references (eg C1='Sheet2'!B1) etc

    I want to be able to assign a hyperlink to a cell on the base data page, and have each cell that references this base data cell pick up the same hyperlink, so thjat not only does it equal the value, but has the link as well.

    I have attached a basic example workbook.

    The yellow cell in D5 is my base data. In cells L5 and O13 i have simply entered " =D5 " so that whatever data is entered into D5 carries through.

    How do i also get the Hyperlink to carry across to these other cells?

    To add context:
    the sheet is for a sporting tournament where some teams have specific sponsors, and i want to be able to link to that sponsors website direct from the team name.

    The team may follow a number of different paths through the tournament draw, which is determined by wins and losses. The sheet is already set up to calculate where they go, and will automatically fill in their team name. All i want to do is be able to have the same hyperlink go wherever that team name goes.
    Attached Files Attached Files
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    359

    Re: How to get Hyperlinks to carry through when using formulas

    Any ideas on this one guys and gals?

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2016 (work) and 2013 (home)
    Posts
    1,164

    Re: How to get Hyperlinks to carry through when using formulas

    In a separate tab put all of the links you want to use and give then names. For instance put this reference in a cell http://www.excelforum.com/excel-formulas-and-functions/ and call it Darren. In cell D5 put this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    When you want to reference Darren in the future, rather than
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. When do and don't formulas carry down when inserting a row?
    By kimbatigger in forum Excel General
    Replies: 3
    Last Post: 03-20-2012, 04:19 PM
  2. Replies: 2
    Last Post: 01-16-2012, 09:22 AM
  3. carry down formulas when inserting
    By jringler in forum Excel General
    Replies: 1
    Last Post: 05-28-2009, 06:42 PM
  4. [SOLVED] Formulas autofill ok but continues to carry tot from 1st column??
    By ET in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2006, 11:00 AM
  5. Hyperlinks in Formulas
    By Smookieman in forum Excel General
    Replies: 1
    Last Post: 01-18-2005, 09:06 PM

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