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

[Cheryl]

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]

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]

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