+ Reply to Thread
Results 1 to 2 of 2

Dynamic Data Validation

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    Dubai
    Posts
    12

    Dynamic Data Validation

    Hi again,
    It looks like I will become addicted to this forum since it provided me with great help.

    I searched for a solution for my problem and found tons of useful ideas, but failed to find one that addresses my problem.

    I am using a sheet for building phases, each phase starts with a quarter and takes X number of quarters to finish. then the next phase should start AFTER the previous phase is finished.

    Example:
    Phase 1 starts on 2008 Q1 and takes 4 quarters to complete so it finishes on 2008 Q4. I defined the quarters in a name range called quarters that the user will selct the start of each phase from. I want to be able to excelude the quarters prior to the completion quarters of the previous phase. In my example, the user should not be able to select starting quarter for phase 2 that is prior to 2008 Q4.

    Is there a way of doing this through data validation?

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    have a look at attached
    uses a dynamic range for second validation list
    Attached Files Attached Files

+ 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. Data Validation
    By sudheesh.e in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-19-2008, 11:36 PM
  2. Auto-Sorting Dynamic Data
    By MAMC84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2008, 11:52 AM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. Data validation won't clear
    By rgarber1950 in forum Excel General
    Replies: 2
    Last Post: 11-06-2007, 02:38 PM
  5. Replies: 3
    Last Post: 05-12-2007, 08:12 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