Help creating single cell Pop-up
Is there a way to make a single cell do the following?
1. Within "Sheet 1", is it possible to display the actual numreical value of a total sum value of a certain data set within the same cell as a if it were a button? For example, the cell "D15" will display "400" as a grand total of subset data and the cell would have a button like effect such as a command button works. 2. Also, from within that same cell, when the cell area (command button?) is clicked it creates a pop-up of the data source with the full data set displayed? |
Create helper columns and extract those values (=MONTH(A2), =DAY(A2), =
YEAR(A2), and sort by the helper columns. -- HTH Bob Phillips "Bill" wrote in message ... Is there a way to make a single cell do the following? 1. Within "Sheet 1", is it possible to display the actual numreical value of a total sum value of a certain data set within the same cell as a if it were a button? For example, the cell "D15" will display "400" as a grand total of subset data and the cell would have a button like effect such as a command button works. 2. Also, from within that same cell, when the cell area (command button?) is clicked it creates a pop-up of the data source with the full data set displayed? |
Thanks Bob. I will give this a try.
"Bob Phillips" wrote: Create helper columns and extract those values (=MONTH(A2), =DAY(A2), = YEAR(A2), and sort by the helper columns. -- HTH Bob Phillips "Bill" wrote in message ... Is there a way to make a single cell do the following? 1. Within "Sheet 1", is it possible to display the actual numreical value of a total sum value of a certain data set within the same cell as a if it were a button? For example, the cell "D15" will display "400" as a grand total of subset data and the cell would have a button like effect such as a command button works. 2. Also, from within that same cell, when the cell area (command button?) is clicked it creates a pop-up of the data source with the full data set displayed? |
All times are GMT +1. The time now is 11:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com