Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hovering Over the data point shows different X-Axis | Charts and Charting in Excel | |||
how to show data in another cell from a drop down box | Excel Discussion (Misc queries) | |||
Changing location of comment when hovering over cell | Excel Discussion (Misc queries) | |||
Automatically Hide row or show by hovering of mouse | Excel Discussion (Misc queries) | |||
show the time I last saved my file just hovering a mouse on a butt | Excel Discussion (Misc queries) |