Using a text date for filtering

[scottishmovies]

Hi Guys,

I have a sheet (Data) which is capturing data from a userform. One column has a formula which converts a date field into a text format.
So, in G2 I have :-

=Text(D2, "MMM-YY")

and I use this to generate monthly reports and charts etc, it works well. I also use a dropdown list so the user an select the month report to run. I would like to automatcally filter the sheet (Data) when the dropdown is changed in the REPORT sheet, based on the selection of the dropdown.

The dropdown is named "reportdate". I would also like to hide several fields and the one with the formula above (G2) is one of them. Is it still possible to filter in VBA if the column is hidden?

Hope that makes sense? Any ideas appreciated.

Thanks,
Pat