Purchase Order with Drop downs that will Auto fill typical informa
 

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

Purchase Order with Drop downs that will Auto fill typical informa
 

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 he

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

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

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

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



rsera wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html