Copy data in new worksheet as per date

T

Tiya

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data as per date into new worksheet. 0
How to copy data as per date into new worksheet? 2
Which Function is use? 1
copy multiple worksheet data from 2 different workbook 5
vba to copy data from sale receipt to next available column in aninventory worksheet 0
vba to copy data from sale receipt to next available column in an inventory worksheet 0
code to put copy of worksheet on desktop 0
Transfer data as per there date in there month. 0

Top