+ Reply to Thread
Results 1 to 3 of 3

Drop Down Menu Dependent On Another Cell

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    2

    Drop Down Menu Dependent On Another Cell

    I am trying to create a cell with a drop down menu that contains numbers (i.e. the user chooses from whole numbers between 30 and 50). I would like the numbers contained in the drop down menu to depend on the value in another cell. Specifically, if there is a number in A1 (say, 40) I would like the drop down in A2 to contain all the numbers within +/- 10 of the number in A1 (30 through 50 in this case). I would like it to be dynamic so that if the value in A1 is changed to 50, the drop down in A2 would automatically contain 40 through 60. I have some basic VBA skills if it is easier to go about it that way.

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Drop Down Menu Dependent On Another Cell

    Hi,

    You can create a dropdown by using a data validation list (Data > Data Validation > Allow: List) and select a list of numbers.
    To create the list of numbers (I used a second sheet starting at A1) with +/-10 I started by referencing A1 from sheet1 in A11 of sheet2 and then above that I used A11-1 and filled up and the opposite below.
    I hope this makes sense (see attached)
    Attached Files Attached Files
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Drop Down Menu Dependent On Another Cell

    Another way.

    With this formula as the source of the drop down in K1 and filled down until you get blanks
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    define the drop down in A2 as List > Source: > K1:K21
    Dave

+ 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. Help requested on dependent drop down menu
    By jun-xin.chen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2015, 06:03 PM
  2. Replies: 4
    Last Post: 09-11-2014, 10:38 PM
  3. Replies: 9
    Last Post: 04-29-2013, 11:58 AM
  4. Cell changes dependent upon drop down menu in a different cell
    By SnoopB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2013, 02:17 PM
  5. [SOLVED] Excel 2007 : new drop down menu based on dropdown menu in previous cell
    By martinpols in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 02:33 AM
  6. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 AM
  7. Replies: 2
    Last Post: 02-13-2006, 12:00 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