Hi,
Is anyone aware of any function or code that I can use to set an auto filter in a macro for example lets say Column F contains start dates and I want to use this sheet going forward but need to be able to run a macro or function or anything that will then automatically filter to only show data for people who started in the last 10 days?
I dont want to do it manually although if that is the only option I will have to, obviously this will change as the days go on so cant set a specific date range and the only manual options I can see are this week OR last week etc without having to go in and untick/tick individual days.
Is anyone aware of any function or code that I can use to set an auto filter in a macro for example lets say Column F contains start dates and I want to use this sheet going forward but need to be able to run a macro or function or anything that will then automatically filter to only show data for people who started in the last 10 days?
I dont want to do it manually although if that is the only option I will have to, obviously this will change as the days go on so cant set a specific date range and the only manual options I can see are this week OR last week etc without having to go in and untick/tick individual days.