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

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'



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