| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hovering over a cell and seeing a data set for the sum in the cell
Hi,
I have a workbook with two worksheets in it. In worksheet 1, I have a sumif equation in A1. In worksheet 2, I have a set of data with 5 columns and 2000 rows. I would like to hover over A1 in Worksheet 1, and have a pop up window (or any other viewing pane), show me only the rows of data from Worksheet 2, that create my sumif quantity in Worksheet 1. Thanks for any suggestion! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hovering over a cell to show all data used in that cell | Excel Worksheet Functions | |||
| Hovering Over the data point shows different X-Axis | Charts and Charting in Excel | |||
| Changing location of comment when hovering over cell | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
Threaded Mode
