Results 1 to 9 of 9

Data validation - limit based on previous choice

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    77

    Data validation - limit based on previous choice

    Hi everybody,

    I am applying data validation to cells and would like to limit the range based on a value entered in the preceding cell.

    In the attached, in column A you can select any month in the list in column H.

    In column B I would like to restrict the list to months after that chosen in A.

    I have been trying to use OFFSET and MATCH but haven't found anything that works yet, does anybody have any advice?

    I'm also not sure how to get round the problem of someone choosing column B first...

    Thanks
    Rich
    Attached Files Attached Files
    Last edited by Ricardo Mass; 09-25-2013 at 05:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  2. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  3. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM
  4. validation rules not working when someone copy paste data on validation cell
    By jthakrar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:36 AM
  5. [SOLVED] data validation-How to set data validation for user to key in 24H time format?
    By crapit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2006, 08:00 AM

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