autofilter linked in different worksheets
 

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

autofilter linked in different worksheets
 

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

autofilter linked in different worksheets
 

Don
This was helpful and I can use it in other areas
but
I cannot use it for my immediate task, do you need furthur explanation of
what I am attempting to do?


"Don Guillett" wrote:

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 childs
Aim is to make the selection of a autofilter on the mother flow to the
childs


.