Auto Generate Sales Against Target Report based on Month Referece

[Bui Ngoc Anh]

Hi everybody !

Now i have to write a report in excel which is sales against target r. The report is on quarter basic . The sales amount is updated monthly and from that , we can know whether is it achived quartelrly target target or not and how much percentage requirement more .
Besides , the more difficult part is that this report is auto generated based on month choosen . It mean the report will have pop up calendar filter option . From that , the user can choose which month they want to see for the report and all the data will be auto populated based on the quarter for that month. The default will be current month .
By now I've just completed all the formular but nerver add in month pop up and also don't know how to make the report auto populated .

I really appreciate all of your help . Thanks a lot