month lookup

[arnab0711]

Hi,
I have this file,where I have from week and upto week in cell c8 & c9,now I want to add a month to it,where,if I select month and from week and upto week,it will give me detail.
I also want like week,from month and upto month

[royUK]

If you set the data up as a proper table with no empty cells then you could achieve this with AutoFilter

[arnab0711]

If it was the matter of autofilter I wouldn't have posted my question in this forum,its a genuine necessity hence this post

[martindwilson]

ooooooh tetchy !
i think the correct response should have been along the lines of

"thanks for the tip, but i'd really like to do this with functions or code, any further assistance would be appreciated"

so for that reason i'm out!

[royUK]

My response is:
"Figure it out yourself"

Why do you expect us to give up our free time to provide you with an answer when Excel has already got features to do what you want? Also,what makes you think a question in Excel general forum rules out AutoFilter? Especially when you can't even reply civilly

[arnab0711]

I think you shold learn to reply civilly
I don't think you should qualify to be a forum administrator

[royUK]

You started the rudeness. After all you want free advice,not me.

The genuine necessity is that you reply civilly,follow all the rules & use Excel properly as advised,not what you think it should be like.

[arnab0711]

ok,I apologize,I had a bad quarrel with my friend,hence the answer.

[royUK]

Apology accepted

[arnab0711]

but your assistance in this is greatly appreciated since the columns from H to the end will be hidden,and some set of people is only going to fillup column e & f,and these figures will be automatically updated in another sheet,which has not been shown here.
pls advice if there is any communication gap

[daddylonglegs]

So can you give an example of what you want to get? Currently you select start week and end week in C8 and C9 and that gives you data in columns C, E and F

You say you want to add month? So does that mean you select month, start week and end week, how would that work, what would be shown?