Refreshing auto-filters -Help!

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

I have worked on a macro which will re-make the selection but for all 30+ pages this would be a real pain to impliment.


Sub ThisWillTakeAges()
Selection.AutoFilter Field:=3, Criteria1:="Carnations (Direct)"
End Sub


Any more thoughts guys?

Ahhhh I ahve to have this finished in 3 hours, any help really appreciated!

? ----------