Excel Sheet Hover Over Cell To Display Data
Posted on 2010-09-03
Basically this is what I want:
I want to be able to hover my cursor over a cell in an excel sheet that then brings up a box showing data that is entered in another sheet within the workbook.
In a workbook I have 2 sheets one labeled names and one labeled ages. On the names tab/sheet I want to be able to hover over someones name (let's say that user is in A1 on the names sheet) I want it to display a number that I have already manually entered on the ages sheet in cell B4.
So let's say I have 45 entered in cell B4 on the ages sheet. When I hover over cell A1 on the names sheet a pop up is displayed that says 45