Hovering over a cell to show all data used in that cell
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. |
Hovering over a cell to show all data used in that cell
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. |
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! |
Hovering over a cell to show all data used in that cell
I think I'd like to get into the VBA. Is there a good place to direct me to start this process?
Thanks! The Excel programming group would be the place. Bernie MS Excel MVP |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com