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.