Hi
thanks in advance
I have a database which contains information related to ATM cards
in Sheet
A B C .............................
1 Card no Account no. Branch Code ...........................
2 123 1001
3 123 1001
4 1002
5 124 1002
6 1003
7 125 1004
8 126 1004

I need the record as follows

A B C .............................
1 Card no Account no. Branch Code ...........................
3 123 1001
5 124 1002
8 126 1004

it will remove duplicate rows i.e. 3
it will remove rows if card no. is blank i.e. 6
it will remove the earlier record & keep latest i.e. 8

I need a macro for this because it is continuing job everyday