+ Reply to Thread
Results 1 to 4 of 4

How to Link a cell value with the detailed table

  1. #1
    Registered User
    Join Date
    12-14-2015
    Location
    Cairo,Egypt
    MS-Off Ver
    2013
    Posts
    19

    How to Link a cell value with the detailed table

    hello ,

    can i ask about how can i when i press on a cell value it shows me the value details from the table on the sheet at background.

    Thanks with high appreciate for your efforts.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to Link a cell value with the detailed table

    Hi and welcome to the forum.

    I'm struggling to understand your requirement.
    What do you mean by 'press on a cell value'? Do you mean select the cell and if so What do you want to happen?
    What details should it show?
    Why at the moment does it show 1250? Is this something to do with C8 on Sheet1?
    If so why not just enter the formula =
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in B2
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-14-2015
    Location
    Cairo,Egypt
    MS-Off Ver
    2013
    Posts
    19

    Re: How to Link a cell value with the detailed table

    Thanks Mr. Richard Buttrey , for your support, but i mean that how can i when i press on the cell on sheet2 "Just a value" , its show me some thing like pop up Msg or dynamic hyperlink , to show me what is the Number full details as a table like in sheet1.

    actually i didn't see some ting like that before , but my manager ask me to make it in a report . so i ask you for your support

    i hope that you got my mind .

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,687

    Re: How to Link a cell value with the detailed table

    Try
    in C2

    =HYPERLINK("# Sheet1! C" & MATCH(B2,Sheet1!C:C,0))

+ 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] Table Header in Index to link to cell
    By Katch22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2014, 07:49 PM
  2. Replies: 2
    Last Post: 08-08-2013, 05:59 AM
  3. Detailed pivot table from multiple sheets?
    By xdskyline in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-14-2013, 09:31 PM
  4. Automatically link each new cell in a table to a new worksheet
    By tragic_fool in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-20-2012, 02:36 AM
  5. How to link a comment to a cell in a Pivot table
    By do585 in forum Excel General
    Replies: 0
    Last Post: 07-15-2010, 02:05 PM
  6. How to assign and link cell value to a table?
    By chamille38 in forum Excel General
    Replies: 2
    Last Post: 07-10-2008, 02:36 AM
  7. [SOLVED] How do I link a cell outside a pivot table to one inside the table
    By GPGTDRVR in forum Excel General
    Replies: 3
    Last Post: 08-16-2006, 09:50 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