+ Reply to Thread
Results 1 to 4 of 4

dropdown lists based on previous cell values

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    dropdown lists based on previous cell values

    Hello
    I have tried information from the site but did not help me 100% (http://www.contextures.com/xlDataVal02.html)

    B2 is drop down lsit,
    C2 is drop down list and should change based on B2. ( I could this )
    D2 is also drop down list and should also change based on B2.....(I could do this too)

    But did not quite work for below rows like B3, C3, D3----B4,C4,D4 and son on..
    When I copied entire row-2 (to row 3) , C3, and D3 are referring to B2 instead B3
    pleas see attache pic that explains with a example

    THank you
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: dropdown lists based on previous cell values

    It's a bit difficult to say without being able to see the formulas in your data validation (I assume that's how you're doing this), but my guess would be that you have absolute cell references in row 2 which means that your validation is fixed to a particular row.

    If you're not sure, could you attach a sample of your workbook (without sensitive data) so we can have a look.
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

  3. #3
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    Lightbulb Re: dropdown lists based on previous cell values

    yeah, its difficult to understand. Please see attached excel file
    D column drop down list is unchanged.
    thanks for your help
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    Re: dropdown lists based on previous cell values

    never mind i fixed it..
    i used

    =INDIRECT(CONCATENATE(B21,"1A"))

+ 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. [SOLVED] Create drop down lists based on data entered in two previous cell???
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-01-2015, 10:26 AM
  2. How to determine values based on a previous cell
    By Kastalarial in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 06:26 AM
  3. Update a dropdown based on previous cell
    By rajaharish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2012, 10:27 AM
  4. run macro based on combination of values from 2 dropdown lists
    By myls_phil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 10:46 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. Macro - auto populate the values based on previous cell values
    By Avinash Kumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2009, 02:02 AM
  7. populating a dropdown based on choice from a previous dropdown
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 03:20 PM

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