OK, I'm using Excel '02. Here's what I want to do but I can't find the answer
anywhere in the help section.

I have 2 worksheets, first one is data entry into 4 columns. The fourth
column being the date. The second workbook is the display of that data. I am
using the calendar 8.0 and I want to be able to click on the date from the
calendar and have the values from the 1st workbook displayed, just as they
were entered on the first workbook, to the right of the calendar for that
date.

Is your question how to use the calendar, or once you have a date from the
calendar, how to get the info on the data entry sheet? Also, do you have
more than one entry per date on the data entry sheet?

"Matt the wire guy" <Matt the wire wrote in
message ...
OK, I'm using Excel '02. Here's what I want to do but I can't find the
answer
anywhere in the help section.

I have 2 worksheets, first one is data entry into 4 columns. The fourth
column being the date. The second workbook is the display of that data. I
am
using the calendar 8.0 and I want to be able to click on the date from the
calendar and have the values from the 1st workbook displayed, just as they
were entered on the first workbook, to the right of the calendar for that
date.

I think what I want to know is how to get the info from the data sheet once I
select the date. Here's the basic jist of what I'm trying to do...

Data Sheet

Reel Gross Tare Net Date
1 800 150 650 07/12/07
2 900 150 750 07/13/07
3 850 150 700 07/13/07

Display Sheet

When I click on the date 7/12/07 it displays (to the right of the calendar)

Reel Gross Tare Net
1 800 150 650

and when I click on the date 7/13 it shows me the data from the 13th. So on
and so forth. I hope this explains it a little better. I cannot figure out
how to make the calendar search for the date clicked and then display that
information on the display sheet.


"Dave Thomas" wrote:

Is your question how to use the calendar, or once you have a date from the
calendar, how to get the info on the data entry sheet? Also, do you have
more than one entry per date on the data entry sheet?

"Matt the wire guy" <Matt the wire wrote in
message ...
OK, I'm using Excel '02. Here's what I want to do but I can't find the
answer
anywhere in the help section.

I have 2 worksheets, first one is data entry into 4 columns. The fourth
column being the date. The second workbook is the display of that data. I
am
using the calendar 8.0 and I want to be able to click on the date from the
calendar and have the values from the 1st workbook displayed, just as they
were entered on the first workbook, to the right of the calendar for that
date.