Hi guys,

Just another quick question, I know it's my thrid and I don't want to be getting greedy here.
Basically, I have an autofilter set on about 30 differn't pages in which all the data is linked to a sheet in my workbook called "calculation sheet".

When the data is removed from the calculation sheet and new data is entered, all the autofilters which link to this page do not refresh automatically, and all the rows previously hidden remain hidden.

What I want to be able to achieve, preferably automatically, but if there is a macro that does it that's just fine, is to refresh all the autofilters to accomodate the new data.

Please please please help

Many thanks