Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hovering over a cell to show all data used in that cell
Hi,
I am trying to figure out a way to quickly show all the data used in a cell on tab A that comes from tab B. Let's say I have in in Sheet 1,Cell A1, a quantity of 10. In Sheet 2, rows 1-4, I have quantities listed in column B. My sumif formula pulls in the total of 10 but I want to hover over Sheet 1 Cell A1 and see all the rows from Sheet 2 rows 1-4. Thanks for any input. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hovering Over the data point shows different X-Axis | Charts and Charting in Excel | |||
how to show data in another cell from a drop down box | Excel Discussion (Misc queries) | |||
Changing location of comment when hovering over cell | Excel Discussion (Misc queries) | |||
Automatically Hide row or show by hovering of mouse | Excel Discussion (Misc queries) | |||
show the time I last saved my file just hovering a mouse on a butt | Excel Discussion (Misc queries) |