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
Bookmarks