I have been searching the forums for a simple macro to filter data for =now() s date. I tried to use the macro recorder but it wont let me use filters. I would imagine that its very simple to do but cant figure it out.

Obviously I would like to revert back to the original once its filtered and the data is used. I have the middle part of the macro working so I just need to know how to filter and reset it back.

Thanks for your help,
Ken