View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rsera rsera is offline
external usenet poster
 
Posts: 1
Default 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