Data Extraction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chicken Man - 23 Feb 2005 17:43 GMT

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

Reply to this Message

VENKAT - 24 Feb 2005 03:13 GMT

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)

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

> 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
[quoted text clipped - 17 lines]
>
>Expand AllCollapse All

Signature

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

Reply to this Message