Hello Sir,Why VBA?
That could easily be done with Formulae
Hello Chihiro,Nothing wrong with using VBA. Just google advanced filter vba and you will find plenty of examples out there.
Hi Chihiro,Have you tried tying advanced filter to Worksheet_Change event?