Macro to filter and copy data from all sheets except 3

[tonywatsonhelp]

Hi Everyone,

I need some help,
I have a document with 3 tabs that are always there and weekly tabs that get added
now the 3 tabs are "Template", "Todo List", and Historic.

now the other tabs are all the same and get created from the "Template" tab but I never know what they will be called or how many sometimes it just one, other time it can be 30+

so heres what I need

I want a macro that will go to every sheet one at a time (excluding

"Template", "Todo List", and Historic.) and create a filter for Columns C17 to H & last row.
Column H has True and False in it I want to show the False rows
Now column C is a date row and I want all dates that are one week in the future or before that.


So basically goto sheet filter

Columns C17 to H & last row (row 17 are my headers)
Filter by Column H show "False"
Filter by column C all dates that are less than today +7 days

then copy this filtered data Columns C:H (if there is any) and paste it in the "Todo List" sheet first free row after cell H20.

so what i get is a Todo list sheet showing all the rows that where false and within the dates

please help if you can

Thanks

Tony​

​

 

[tonywatsonhelp]

Bump