Hovering over a cell to show all data used in that cell
"Bernie Deitrick" wrote:
Eden,
You can't do that without a lot of VBA, but what you can do is select the cell, press F2, select the
cell references (the "Sheet2!B4:B24" part of the formula =SUMIF(Sheet2!B4:B24,"2") and press F9.
That will show you the values. Then press Escape when you are done, and the formula will revert
back to having a reference.
If you used a pivot table instead of SUMIF, then you could just double click the sum value and Excel
would create a new sheet with all the values that were used to create the sum.
HTH,
Bernie
MS Excel MVP
"Eden397" wrote in message
...
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.
I think I'd like to get into the VBA. Is there a good place to direct me to start this process? Thanks!
|