Replicating Autofilter across identical sheets?

[rhyspippard]

If I set an Autofilter custom date range within column A of sheet1, is it possible for this to be replicated (within an identical set of data) on column A of sheet2?

 

[BrianB]

Yes.
Record a macro of setting the autofilter and run it with the another sheet active.

Otherwise come back with the code and more specifics on what you need.

 

[rhyspippard]

Will a macro update sheet2 each time I change the Autofilter on sheet1?

I need the Autofilter to run simultaneously on both sheets

If so, then this would be exactly what I need

 

[BrianB]

Yes. On its own the change of an autofilter does not trigger any event that can be trapped with a macro. The trick is to put =NOW() into a cell somewhere which forces the sheet to recalculate at that time.

We can then use the Calculate event.