+ Reply to Thread
Results 1 to 2 of 2

Drop Down List & Auto Fill

  1. #1
    Registered User
    Join Date
    09-02-2007
    Posts
    1

    Talking 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.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480
    the combobox from the controls tool bar has autofill

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1