Copy Data as per date into new worksheet.
 

Hi to all
My Filed is like...
Date,Group,PartyName,Amount
1-july, Payment,abc,2345
1-july,Payment,xyz,6790
1-july,Recipt,pqr,8900
2-july,recipt,jjj,9000
2-july,payment,mmm,8907

I have data which i want to copy, Every day as per Date into new worksheet
with date name of worksheet. In New Worksheet it should be copy as per Group
filed, in group filed i have Payment & Recipt only.

It should copy like

Date:- 1-July
a1, b1, c1, d1, e1, f1
Payment, PartyName,Amount Recipt,Partyname,Amoumt.
Payment,abc,2345 Recipt,pqr,8900
Payment,xyz,6790

and if any new enrty done on old date it should copy into that date sheet
only.
Any help
Thanks

Tiya