Data Selection and Filtering Macro - Tweaking the code

[Andrew.Trevayne]

Dear all,
Need your help once again. Recently another forumer helped me with creating a Macro.

Hi everyone,
I would like you help once again on a Macro that does some filtering on a Data Source.
On my example I have 2 sheets, "Summary" and "Data".
I have a bunch of dropdown list on my "Summary" page.
I would like to be able to do selections on these dropdowns and when I run the macro, I wanted to copy the data from the sheet "Data" (based on my dropdown selections).
It's sort of filtering?
Also I would like to get the sum for the period selected.
Attached is a dummy spreadsheet which would probably explain. I hope you could take a look and help me.
Thank you so much.

Here is the link --> http://www.excelforum.com/excel-prog...ing-macro.html

It is working as expected however I need a little bit of modification.
See, when I select the period (date) I get the results. However when the period selected on my dropdown list does not exist on my "Data" sheet, I run into an error "Type Mismatch"
Would you be able to help me modify the below code so that if the period selected does not exist, it will only put 0 or blank on the first line of the table (B to F).
In my attached example, I removed "December" from the "Data" Sheet, if I select it on the list of my MainPage, it should not have an error message rather it will be give me results of "0" or blank on the table of my "MainPage" sheet.

Here are the current codes:

Please Login or Register  to view this content.

Thanks again and I hope you could help me and take a look.

Regards,
Andrew

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[Andrew.Trevayne]

Please Login or Register  to view this content.

Kind regards
Leo

This is wonderful Leo. Thank you so very much.
Appreciate all the help.

Cheers,
Andrew