Filtering an entire workbook

Hi Liz

Thank you for your question

I have explored the sheet grouping tools and it seems that all filtering options are disbaled when sheets are grouped together. Thus it seems that it is not possible to filter several sheets at the same time, using standard excel tools

It is however possible to write a macro that would do this. This would however take the best part of a day to complete and is beyond the scope of the forum. We could however provide assistance on a consulatncy basis. If you wish to go down this route, please contact our enquiries team

Regards
Stephen