i need to solve some of 3 excel problem which i attached the excel sheet

hi guys,

can u pls help me out the problems of excel 3 problems to solve pls refer the excel sheet . pls guys its urgent.....

I don't sure that can solve your task.

good job bro its works thank you!....

what about any idea of other 2 problem can u help me to solve......pls

Bro,

i the excel sheet of select monthly base...

i need exactly monthly wise the data to be updates so if i select the "F2" drop down list of months the below table to be changed based on the month

eg:- if i select February in "F2" the Below table of column date and other column to be changed auto populate from " January to February "

if i select March in "F2" the Below table of column date and other column to be changed auto populate from " February to march "

all this in the same excel worksheet .....

all the data to be based on the months i selecting....

Originally Posted by avk

Dear sathishsusa, Why not maintain all data under one table? For maintain separatly table, any special reason.
I suggest you to maintain all data under one table, its more healthy sound.
Kindly do the needful & attach revised file.

Deaar avk,

thank you for ur suggestion yes if i want to maintain the data in all but i need to change all the data to be in main department and monthly based so i attached the revised file what i need to output pls check out the file bro....
when i selecting the department and months based the data to change to enter new rows by adding employees details.

HI Bro,

Excellent work its working perfectly i am very happy bro thank a lot.....

Thanks to all....

hi,

i want one more help from you when i filter the data by months based the pivot chart is not updating with filtering months auto populated.

i doing separately to filter the required months in pivot chart so i need if i doing the month based on the filter data the pivot chart to populate only the selected month wise.

can u please apply the code for the pivot chart too.