New Sheet Autofilter Copy

[Zimbo]

Hi All,

I have vba code that copies a template sheet and names it according to a cell entry. I then have another macro which autofliters the contents of the sheets excluding the first 2 sheets by a dropdown.

The issue I have is that the new sheet seems to have the opposite autofilter attributes to the existing sheets.

Is there any way to ensure it is the same as the existing sheets or cancel all sheet autofilters prior to its copying.

I have included some of the code with my poor attempt to equal the next sheets autofilter.

Please Login or Register  to view this content.

Any help is great.

Cheers

Adam