+ Reply to Thread
Results 1 to 4 of 4

Select one cell and display another?

  1. #1
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Select one cell and display another?

    Hi Everyone
    This is my first post on the forum - here goes.

    My application uses a number of sheets in the same workbook
    Certain cells in the 'master' sheet jump to cells in other 'slave' sheets to see data using the hyperlink function. I then hyperlink back.

    I would like to hover over the cell in the master sheet (or select it without jumping) and have the contents of a cell (a text 'comment') from a slave sheet appear in a nominated cell on the master sheet.
    When the cell in the master sheet is deselected, the 'comment' to disappear.

    The idea is to view the comment to see if it is necessary to do the jump but always have the comment appear in the same place on the master sheet. I want to ceate a sort of 'jump only by exception' facility for the user. Any ideas please?

    With many thanks
    barry
    Last edited by barryleajo; 06-29-2010 at 05:21 PM.

  2. #2
    Registered User
    Join Date
    06-20-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Select one cell and display another?

    What about :

    =HYPERLINK("#"&"Sheet2!A6";"Value in Distination cells is : "&Sheet2!A6)

  3. #3
    Registered User
    Join Date
    06-20-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Select one cell and display another?

    ups try this one

    =HYPERLINK("#"&"Sheet2!A6","Value in Distination cells is : "&Sheet2!A6)

  4. #4
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: Select one cell and display another?

    Thanks poul
    good for you to take the trouble to reply

    I am using the following VBA code to store the current cursor location in 'Ref Sheet'!B3
    This updates automatically whenever you move the cursor in whatever sheet.

    I can then test the contents of this cell.
    If the cursor is in a specific location I can get it to display something in <known location>.
    If not then set <known location> to blank.


    Please Login or Register  to view this content.
    Hope this may be of use to others.
    Last edited by barryleajo; 06-29-2010 at 05:56 PM. Reason: To use CODE tags on advice of guru

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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