How to use macro filter excel?

@fairymemay - Here you go (107.9 KB)

Currently I have the input date of 22/05/2021 so you see 4 rows filetered, and if you change the date to 20 you will see no rows. Please do delete the Output sheet try both the dates

Once you understood what is happening, Repeat the process for CaseCH sheet by yourself.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.