#1
|
|||
|
|||
Data Validation
I am having data for two years, i.e 2010 and 2011.The query is if i enter a 2010 in a particular cell it should dispaly aug,sep.oct,nov, dec and if 2011 is entered it should display jan,feb,mar,apr,may,jun,jul,aug,sep,oct,noc,dec
It will be highly appreciable if this is solved Janak Last edited by janak; 12-09-2010 at 09:06 PM. |
#2
|
|||
|
|||
Hi,
your question, wanted solution and data structure is difficult to understand. Could you please provide a sample sheet with your data and how you want the result to look like. By this, someone will probably have a bigger chance to help you. Kind regards Bjorn |
#3
|
|||
|
|||
Year
Dear Friends,
As per the reply received,i am attching the sample fle for more easy unnderstanding Explanation of result expected is explained in file itself Regards, Janak |
#4
|
|||
|
|||
Hi,
I am still not sure that I got you right, but here is an attachment where I have entered a formula in cell B2. Kind regards Bjorn |
#5
|
|||
|
|||
Year
Dear Friend,
Thanks for showing interest in my problem,actually problem is when i select or type 2010 it should me the drop down from month august to december and when i select or type 2011, itshould show me the drop down from january to december For 2010----------it should be show drop down as aug,sep oct,nov.dec For 2011----------it should be show drop down as jan,feb,mar,apr,may,jun,july aug,sep oct,nov.dec Waiting for response Janak |
#6
|
|||
|
|||
Hi again,
ok, now I think it is clear what you need! Here is an attached solution (see file). Short explanation. I created a data validation for the year (only 2010-2011 allowed). I created two lists with months in sheet2, and gave them the names "List2010" and "List2011". At the top of sheet2 there is a formula in Cell B1, creating the correct name depending on the selected year. This cell is given the defined name "ValidListName" (otherwise you can't refer to a "valid range" on another worksheet). At last I entered a data validation for the cell with the selection of month. I choosed "List" and entered "=ValidListName" as reference for valid entries. I hope this works as you wanted! Kind regards Bjorn |
#7
|
|||
|
|||
Year
Dear Bjorn
Excellent,this is what i want You really rock buddy.............. fantastic Janak |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto insert current month's name and current year | Styler001 | Word | 4 | 01-25-2010 06:40 PM |