This should prove useful.
http://www.ozgrid.com/VBA/autofilter-criteria.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ross in Oz" wrote in message
...
I have 3 worksheets all containing autofilters with the same data (other
data
in the rows are different in the woksheets)
i.e. Autofilter columns will be identical on all worksheets
I want to call one a mother and the others clilds
Aim is to make the selection of a autofilter on the mother flow to the
childs