Select Month in drop down and week no. come in another drop down.

[MohitMathur1234]

Please find the attached file.
Where in one cell I have Drop down to select month and another cell I want week come in drop down.

 

[udprocks]

Hi,

In this how u have define Weeks...?

If you define Weeks in a helper column respect with Months, it should be easier.

 

[Somendra Misra]

Hi Mohit,

Go through The attached file, hope this will solve your purpose. Go through the name manager.

Regards,

 

[NARAYANK991]

Hi Mohit ,

An alternative method.

Narayan

 

[MohitMathur1234]

Thank you so much guys, but it's very difficult to understand. I have tried the same but unable to find the same output.