Use Data from one sheet to populate Purchase Order on another sheet -Excel 2002

Hello,

Wonder if this is possible..

Sheet1 - has a 'list' of parts that need to be ordered - their description,
qty, type of material, part number etc

Sheet2 - I want to create a requisition from those items listed on Sheet1
based on type of material...

Basically need to take the data from Sheet 1 (can be 50 - 200 items/parts)
keyed in by designers and create a purchase order requisition for our
vendors/suppliers based on the type of material. Is there a way to extract..
say. material is H20.. and of them 50 items keyed in.. 10 of them are H20..
so that I can fill in the qty, description, part number and type of material
automatically on the requisition..

I know how to use vlookup to extract information to automatically fill in
the address now from a list on another sheet.. and filter directly on Sheet
1 which gives me the kind of information I need.. but I don't want to have
the employee just paste.. if possible... in case they miss something...
actually its my supervisors request to some how have a dialog box or
something asking for type of material.. so that it can be filled in.. or the
filter result from sheet 1 connected to this sheet.

I know a database would be easier.. but we are not yet at that point.. this
is an interim solution...

Thanks in advance for your assistance..

Debra
Fri Apr 30 21:07:48 CDT 2004

You could use data validation and VLookup formulas to create a purchase
order requisition form. There's an example on my web site:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Order Form'


Cheryl wrote:
> Hello,
>
> Wonder if this is possible..
>
> Sheet1 - has a 'list' of parts that need to be ordered - their description,
> qty, type of material, part number etc
>
> Sheet2 - I want to create a requisition from those items listed on Sheet1
> based on type of material...
>
> Basically need to take the data from Sheet 1 (can be 50 - 200 items/parts)
> keyed in by designers and create a purchase order requisition for our
> vendors/suppliers based on the type of material. Is there a way to extract..
> say. material is H20.. and of them 50 items keyed in.. 10 of them are H20..
> so that I can fill in the qty, description, part number and type of material
> automatically on the requisition..
>
> I know how to use vlookup to extract information to automatically fill in
> the address now from a list on another sheet.. and filter directly on Sheet
> 1 which gives me the kind of information I need.. but I don't want to have
> the employee just paste.. if possible... in case they miss something...
> actually its my supervisors request to some how have a dialog box or
> something asking for type of material.. so that it can be filled in.. or the
> filter result from sheet 1 connected to this sheet.
>
> I know a database would be easier.. but we are not yet at that point.. this
> is an interim solution...
>
> Thanks in advance for your assistance..
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Cheryl
Tue May 04 09:31:17 CDT 2004

Thank you very much for the information.. It's great.. !


"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:40930674.6060401@contexturesXSPAM.com...
> You could use data validation and VLookup formulas to create a purchase
> order requisition form. There's an example on my web site:
>
> http://www.contextures.com/excelfiles.html
>
> Under 'Data Validation', look for 'Order Form'
>
>
> Cheryl wrote:
> > Hello,
> >
> > Wonder if this is possible..
> >
> > Sheet1 - has a 'list' of parts that need to be ordered - their
description,
> > qty, type of material, part number etc
> >
> > Sheet2 - I want to create a requisition from those items listed on
Sheet1
> > based on type of material...
> >
> > Basically need to take the data from Sheet 1 (can be 50 - 200
items/parts)
> > keyed in by designers and create a purchase order requisition for our
> > vendors/suppliers based on the type of material. Is there a way to
extract..
> > say. material is H20.. and of them 50 items keyed in.. 10 of them are
H20..
> > so that I can fill in the qty, description, part number and type of
material
> > automatically on the requisition..
> >
> > I know how to use vlookup to extract information to automatically fill
in
> > the address now from a list on another sheet.. and filter directly on
Sheet
> > 1 which gives me the kind of information I need.. but I don't want to
have
> > the employee just paste.. if possible... in case they miss something...
> > actually its my supervisors request to some how have a dialog box or
> > something asking for type of material.. so that it can be filled in.. or
the
> > filter result from sheet 1 connected to this sheet.
> >
> > I know a database would be easier.. but we are not yet at that point..
this
> > is an interim solution...
> >
> > Thanks in advance for your assistance..
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>