I was just wondering if you guys know how to make a Macro whereby it will perform a new advanced filter whenever there is a change in the source for the advanced filter, let's say in Sheet1.

That means that the copied data from the advanced filter will automatically be updated in say Sheet2 everytime the info from Sheet1 updates.

Other than that, I would like to make the data be sorted according to Column B then Column C whereby the Headers are at Row 4.

This is really urgent. I hope someone out there knows how to solve this.

Jasper