Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop Down List & Auto Fill
I have a workbook with two sheets pertaining to this issue. I have one sheet
(A) with a keycode, description, unit of sale , and cost. This sheet has multiple listings of products EX. item code Description Unit of Sale Cost 1/4ply 1/4" BC Plywood Sheet $12.50 Sheet (B) A blank version of sheet A with multiple blank fields for filling in various items and quantities from Sheet A. Item Code Material Sale Unit Estim. Unit Cost Quantity of Units (cont'd) Estimated Cost I want it to where the all the item codes on sheet (A) appear on a drop down menu in a column on Sheet (B). Also, once the appropriate code is chosen I want it to auto fill the appropriate information associated with that item code (description, unit of sale, and cost) in that row. I've been playing with validation fields, lists, and have not found a combination that works between sheets and autofills. Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists and Auto Fill | New Users to Excel | |||
Auto fill drop down stops at second cell | Excel Discussion (Misc queries) | |||
Auto Fill from Drop Down list | Excel Worksheet Functions | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
Creating an auto fill or drop down | Excel Discussion (Misc queries) |