Advanced Filter In Excel VBA

[Sudheer]

I Have Sheet Named "A" in that i have a 9 Digit Number in a Column For Eg 461000123, 462000124 etc.
Here if The Third digit in The Number is "1" Those Cells Should be copied to one sheet Named "X".
if The Third Digit in The Number is "2" Those Cells Should be Copied to another Sheet Named "Y".

Plz tell Me the Formula.

Thanks In Advance

[pecoflyer]

Hi and welcome
please post a sample sheet showing what you have already achieved and where it went wrong. Thx