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!