+ Reply to Thread
Results 1 to 8 of 8

Change multiple cells based on dropdown list value.

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Change multiple cells based on dropdown list value.

    Hello,

    I'm having an Excel workbook with two sheets, one base sheet and one 'database' sheet. The database sheet consists of main-processes with several sub-processes, it looks something like this:
    Capture.PNG
    Now, in the main sheet, there are dropdown lists of the main-processes. I want the user to select some main-process, and all the sub-processes to appear automatically per main-process.
    I also want a template version of the sheet, where other main-processes, with various amounts of sub-processes, can be added in the database. The selecting from the menu should then still work without changing the formula or VBA code.

    I'm looking forward to your answers!

    Edit: I've added an example file with more explanation.
    Attached Files Attached Files
    Last edited by NKuip; 09-25-2017 at 04:46 AM.

  2. #2
    Registered User
    Join Date
    09-19-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Re: Change multiple cells based on dropdown list value.

    Does someone has an idea how to fix this?
    Or is my explanation not clear enough?

  3. #3
    Registered User
    Join Date
    09-19-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Re: Change multiple cells based on dropdown list value.

    No one has any ideas?

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Change multiple cells based on dropdown list value.

    Hi NKuip
    Please, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to 'Manage Attachments' to open the upload window.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Change multiple cells based on dropdown list value.

    Maybe?

    Please Login or Register  to view this content.

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Change multiple cells based on dropdown list value.

    or maybe so
    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-19-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Re: Change multiple cells based on dropdown list value.

    @nilem

    I get your principle, with the second list. But all sub-processes have to be displayed anyway.

  8. #8
    Registered User
    Join Date
    09-19-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Re: Change multiple cells based on dropdown list value.

    I get your principle, with the second list. But all sub-processes have to be displayed anyway.

    edit: Sorry for the double post, I want to delete this, but I don't know how
    Last edited by NKuip; 09-26-2017 at 02:40 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dropdown List from multiple cells
    By mattbarb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2014, 10:08 AM
  2. Dropdown list based on other cells vaue
    By little_ghost in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-27-2014, 09:59 AM
  3. Change multiple pivot table filters with dropdown list in cell
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2013, 09:19 AM
  4. Change values in cells based on dropdown selection
    By Gert Van Dessel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2013, 09:31 AM
  5. [SOLVED] VBA to hide cells based on dropdown list using If/Else/Then
    By JOHNROK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 06:13 PM
  6. Change cell from dropdown list and clear other cells in row
    By Dale Schultz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 09:30 AM
  7. Replies: 1
    Last Post: 06-21-2011, 11:46 AM

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