Auto Sort Data By Date Into Different Sheets

[bivouac]

Morning,

At work, we have a log that is filled throughout the day. At the end of every month, I export the log into excel. I take the log and manually sort each date into its own sheet using cut and paste. There are hundreds of entries for each day. Is there a way to accomplish this automatically to where I can auto sort each day into its own sheet?

 

[Marc L]

Hi,​

​

in fact this is not a sort but a filter then a Cut to another place …​

​

It should be done via some VBA loop using an advanced filtter for example.​