Data Extraction
 

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





Expand AllCollapse All

use vlookup function-see excel help on this function.

give a name to the whole database in sheet2 for e.g. mydatabase
if in sheet1 A2 is date 1/12/05 in B2 type =VLOOKUP(A2,mydatabase,2,FALSE)

================

On Wed, 23 Feb 2005 09:43:05 -0800, Chicken Man wrote:

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


Expand AllCollapse All




--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/