Searching for Data
 

My goal is to create a lengthy spreadsheet on sheet two, and use sheet one as
a summary page. On the summary page I want to type in a date and then fill
in fields on that page with data from page two specific to that date. All of
the data on sheet two will be separated by date.

eg. by typing in 1-12-05 (one the summary page) I would pull the data to
fill in the fields as laid out below.

Sheet 1 Summary

date item produced lbs. produced hrs worked
1/12/05 widgets 7 5


Sheet 2

date item produced lbs. produced hrs worked
1/12/05 widgets 7 5

1/14/05 candels 11 24