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?