Purchase Order with Drop downs that will Auto fill typical informa

[Guest]

In excel 2003

Create a drop-down list Help
Assistance > Excel 2003 > Working with Data > Validating Cell Entries

Looking for a Drop Down list that will predefined on any Line of the
purchase Order common information-or additional drop downs based on this
information

Item # Qty Description Sytle Profile Unit Length Eave Unit
Cost Unit Total $
SF/LF/Size Notch

1 3 Vm Zinc RoofShield (480) Coverage FALSE 164 N/A $13.00 Roll $0.00
0 0
0 0 Vm Zinc RoofShield (480) Coverage A 1 11.29 96 Y-2 $3.50 Panel
So When I Select Product from the drop down- It will fill in a series of
information related to this product
Purchase Order with Linked drop downs for repeat products

 

[Debra Dalgleish]

You could use data validation in one cell, then VLOOKUP formulas
to return the matching values in the adjacent cells. There are
instructions and examples here:

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

There's a sample invoice that uses data validation and VLookup formulas
here:

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

Under Data Validation, look for 'Invoice for Selected Number'