+ Reply to Thread
Results 1 to 5 of 5

Link to where data is pulled from in a range?

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Link to where data is pulled from in a range?

    Hello,

    I'm not sure if this is a solvable problem, but I am wondering if there was to automatically, hyperlink to the cell in my sheet where my indexed list is pulled from.
    Paraphrasing, I have a sheet where I pull in the specific information based on met criteria from another sheet in the workbook, using this formula:
    =IFERROR(INDEX(INDIRECT("Data!$C$3:$C$500"),MATCH(B$663&" "&ROWS($A$1:A8),Data2!$CO$4:$CO$500,0)),"")

    If I need to change the raw data, I need to first find it in my other sheet which doesn't take long, but would make life easier if I was able to select the cell which contains the above formula... and when I select it, it takes me to the cell it's pulling the returned results from.

    Thank you,
    Kanuck

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Link to where data is pulled from in a range?

    This would be the start of what you want...
    HYPERLINK("#"&"'"&INDEX(Sheetnames,ROWS($A$2:A2))&"'!A1")

    All you then need to do is adjust the bolded part (A1) to give you the cell to go to.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Re: Link to where data is pulled from in a range?

    I'm not sure I quite get this one. Do I add that above formula to the existing ones in my cell? To specify as well, the data that is getting pulled in is dynamic, so won't be able to specifically reference a cell.

  4. #4
    Registered User
    Join Date
    09-17-2018
    Location
    Toronto
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Link to where data is pulled from in a range?

    What he means is you can right-click in the cell and add a hyperlink to the cell where the data is referencing.

  5. #5
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Re: Link to where data is pulled from in a range?

    I've been playing around with this and can't seem to get it to work for me.
    Below is where I have it based on the formula provided above, but cannot for the life of me get it to link to the cell my data is getting pulled from.
    =HYPERLINK("#"&"'"&INDEX(Data!$C$3:$C$500,MATCH(B$919&""&ROWS($A$1:A5),Data2!$CO$4:$CO$500,0))&"'!Data")

    Thank you,
    Kanuck

+ 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. Help Organizing Data Pulled from Web Query
    By caveatze in forum Excel General
    Replies: 4
    Last Post: 01-09-2018, 07:18 PM
  2. Select range of dates not pulled into chart correctly
    By excelnewbie2017 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-30-2017, 11:01 AM
  3. Working with data pulled from another program
    By D Taylor in forum Excel General
    Replies: 5
    Last Post: 08-14-2017, 11:40 PM
  4. [SOLVED] Summing a Named Range when said name is being pulled from another cell
    By newfrito11 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-18-2016, 11:22 AM
  5. Formatting data pulled from web
    By cps439 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2011, 04:35 PM
  6. Identifying non-pulled data from Vlookups
    By rhyan66 in forum Excel General
    Replies: 4
    Last Post: 07-07-2010, 04:26 PM
  7. [SOLVED] Refreshing Data Pulled Thru a Function
    By Chris Brown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2005, 03:05 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