Results 1 to 2 of 2

Data validation with conditions

Threaded View

mingali Data validation with... 08-06-2010, 10:40 PM
DonkeyOte Re: Data validation with... 08-07-2010, 02:40 AM
  1. #1
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2010 (office) 2013 (home)
    Posts
    256

    Data validation with conditions

    Hi

    I am thinking of setting a cell with data validation by a list - Jan 2009 to Dec 2013. However, i would like to have the cell only to be shown current year options. ie although i have a list from jan 2009 to dec 2013, but only Jan 2010 to Dec 2010 will be shown as options in year 2010. when new year 2011 comes, it will automatically change the option from Jan 2011 to Dec 2011.

    Is it possible? If so, how to achieve it?

    thanks
    Last edited by mingali; 08-07-2010 at 03:13 AM.

Thread Information

Users Browsing this Thread

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

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