Closed Thread
Results 1 to 3 of 3

Drop Down List to populate multiple values in multiple cells

  1. #1
    Registered User
    Join Date
    05-27-2017
    Location
    Greenville, Texas
    MS-Off Ver
    2013
    Posts
    14

    Drop Down List to populate multiple values in multiple cells

    How do I have a drop down list (already created using data validation) to create multiple values to automatically populate in multiple cells? For example:

    Drop down lists consists of series of door sizes: 10x10, 12x10, etc.

    If I click on 12x10 I want it to populate a 1 (in A15), 13 (in A18), 1 (C15), etc. etc. HOWEVER, I want different values to populate for the different items chosen in the drop down menus.

    CAN THIS BE DONE?????

    Thank you for any help.

  2. #2
    Registered User
    Join Date
    05-27-2017
    Location
    Greenville, Texas
    MS-Off Ver
    2013
    Posts
    14

    Re: Drop Down List to populate multiple values in multiple cells

    I will have closed and post in VBA/Programming.

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Drop Down List to populate multiple values in multiple cells

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create a multiple drop down list that will populate data.
    By Acousticlife81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2017, 03:42 PM
  2. Replies: 18
    Last Post: 11-16-2016, 08:01 PM
  3. Using Multiple Drop down List to populate Multiple Ranges
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2015, 04:48 PM
  4. Need a drop down list to populate multiple cells with specific data
    By tbo812 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 02:08 PM
  5. [SOLVED] Populate Values in Multiple List Boxes based on Multiple Criterias
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-09-2013, 11:39 AM
  6. [SOLVED] From drop down list selection populate multiple Cells
    By logcabin123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2012, 12:43 PM
  7. how to create a drop down list that will populate multiple cells after selected
    By aaronriggle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 06:59 PM

Tags for this Thread

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