Speed up Macro

[30136353]

Hi,

2nd Post today but final configured this Macro to work how I want, but seems very slow and clunky, possibly the show all data lines?

Can anyone help in speeding this up?

Thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ear-filter-macro-post5328485.html#post5328485

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).