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

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

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

Attached Files

year.xls (17.0 KB, 14 views)

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

Attached Files

year_v2.xls (20.5 KB, 18 views)

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

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

Attached Files

year_v3.xls (19.0 KB, 16 views)

Dear Bjorn

Excellent,this is what i want

You really rock buddy..............

fantastic


Janak