Hi

I have 12 worksheets labelled months of the year. On each sheet I have 8
tables listed like this.

Purchase Sales
Purchase Sales
Purchase Sales
Purchase Sales

Each table is for a different grain commodity (4 in total)
I have added filters and subtotals so I can drill down further to see what
different types of commodity and loads are left. However, I would like to
filter the purchase and sales separately but as they are side by side, when I
filter purchase the sales side shrinks too. Is there any way I can filter
the purchases and the sales side stays as it is? And vise versa.

Many thanks for your help.