Filtering table daily, and printing the filtered data

[resiexfor]

Hello,

I have a file; that's being populated from other different files.
The file contains simple data patient name, data and few empty cells.

Now each month, I come to the pain of printing each day alone. And to do that; I filter the table by date (like shown in the example)

And then print the result.

The step to filter and choose date is really taking time, so i was wondering if excel is having a way to auto-filter by "next" or "previous" ??

Hope you got my point?

I will attach a file of how I imagined it.

Thanks a lot for your help in advance.

[tim201110]

Please Login or Register  to view this content.

[resiexfor]

Thanks @tim201110

I tried edit A1 content, but it won't work as the first time i open the file..

Am i doing it wrong?

Thanks for your help.

[tim201110]

https://support.office.com/en-us/art...e-16fed1a7e5c6

[resiexfor]

Hello,

I had macros enabled. and still not working.

[tim201110]

Auto Record a macro: filter just 04.01.2018 and post its code here

[resiexfor]

Please Login or Register  to view this content.

[tim201110]

Please Login or Register  to view this content.

[resiexfor]

Thanks @tim201110

That fixed my issue.