Macro for Filters

Hey Guys,

I have an excel sheet which requires manually updating every month. I manually copy some reports in to seperate sheets, then apply a filter on some of the fields. This then in turn updates my dashboard graphs with the data.

I have detailed the filters in a comments box above the column filter. There are 5 reports in total

would anyone be able to automate the filters for me with a macro - im exremely novice at doing macros.

I have attached the file in question.

It would make my life a lot easier each month if you could help.



Many thanks,

Looking at your attachment.

Please explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

what i need to be able to do is keep the filters at the top without loosing them and having to go in to each sheet each month.

Please explain in detail what you mean by this statement. You don't lose the filters unless you manually remove them so I'm not sure what you mean by

i need to be able to do is keep the filters at the top