Filter data and hide others

[xtopher2711]

Hi everyone,

I need your expert knowledge on an excel sheet.In fact i have a sheet with billing reports in it and i would like to have a vba code which could filter the dates of billing and in the same time hide the other data depending on the billing date i choose.

The goal is that i shall send these data through a mail with a button.

Here is my file: billing date is in cell C