Showing all data related to the quantity in one cell

[Eden397]

Hi,
I am trying to find a way of showing all the data in a popup type of form
when I hover over a cell. Lets say I have 2 worksheets in one overall
workbook. In tab A in cell A1 I have a sumif quantity of 43. I want to
hover over A1 and show all rows of data in my second tab B. Is there a way
to do this? Thanks

 

[sally t]

I'm not sure if there is but you could always look at the Watch Window on the
Formula Auditing Toolbar - that does something similar in that you can
'watch' what's happening in other cells whilst not actually being on them,
you can add many cells to watch perhaps?
Sall