Hello all,
I have scoured the the net to find a none VBA method of displaying a cell value from another cell by hovering over the active cell.
just as how "Khalid NGO Excel Ninja" gave an example using a hyperlink (Right Click > Insert > Hyperlink > Place in This doc > ScreenTip), my result should end up looking something like this, only that it should display a value that it is making reference to.
so if I have a column A for example having the values shown below, I would want see the name values of column C displayed when I hover/select the cells in column A
Column A column B
141 $ 600.00
30 $ 300.00
94 $ 3,000.00
67 $ 3,000.00
329 $ 300.00
Column C Name
141 Dermot
30 Johnson
94 Lesa
67 Meliesa
329 John
I have scoured the the net to find a none VBA method of displaying a cell value from another cell by hovering over the active cell.
just as how "Khalid NGO Excel Ninja" gave an example using a hyperlink (Right Click > Insert > Hyperlink > Place in This doc > ScreenTip), my result should end up looking something like this, only that it should display a value that it is making reference to.
so if I have a column A for example having the values shown below, I would want see the name values of column C displayed when I hover/select the cells in column A
Column A column B
141 $ 600.00
30 $ 300.00
94 $ 3,000.00
67 $ 3,000.00
329 $ 300.00
Column C Name
141 Dermot
30 Johnson
94 Lesa
67 Meliesa
329 John