Hello People,

I have got a list of records in one worksheet which keeps changing every
month.
I want to filter these records based on two criterias and copy the data in
two separate sheets using Macro. Appreciate if anyone can help.

The table looks something like below

DESCRIPTION Account No Cost Centre Amt SJ
TEAM LEADER GIFTS 56240002 1151 250.00 SJ1
BROC FRAG - CAMP 15 14121501 281.00 SJ 2
INTERCO CHGS-BRANCH OPS 58920001 3401 245.38 SJ1
BROC FRAG - CAMP 17 14121701 166.52 SJ 2
BROC FRAG - CAMP 03 14120301 248.05 SJ 2

Every month the above list keeps changing. I want to create two separate list
One list for all rows which contains SJ1 and another one for the rows which
contains SJ2 (Referring to the last column in the table). I want a macro to
copy the filtered data to TWO separate sheets after the list has been updated.

Any help is appreciated.

Thanks