Hi,
Another solution may be by formula in conditional formatting...

Link sheet1 to sheet2 and then do conditional formatting with formula to include...

Like Autofilter columns A to Zwith condition that rows visible if column C has values 'aa' and 'cc'
Other rows hidden or deleted....

Do you think this is possible.

Regards

Is it possible??