Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-Fill Data in alphabetical order? | Excel Worksheet Functions | |||
Purchase order with auto numbering | Excel Discussion (Misc queries) | |||
Fill and Font Color Drop Downs Mostly White with Random Colors | Excel Discussion (Misc queries) | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel |