E
Eden397
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!
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!