Independent tables/filters

[Wries]

Hi All,

I have query about filters in excel 07. I have monthly sales report which includes more than one tables (gross sales, sales by accommodation, supplier resort etc) and i need to place filter for each table separately.

My point is that the tables are next to each (not under) and if I apply criteria it hides those rows that do not match indeed, but affects rows in other tables as well.



I need to have filters/tables act independently within one sheet.

Is there any possibility how this can be set?

Many thanks,
Kind regards,
Wries