Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
copy date from worksheet to another worksheet (same File0 | Excel Discussion (Misc queries) | |||
Copy worksheet to another worksheet and the date is plus 1 day. | Excel Worksheet Functions | |||
How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
Copy Modified Worksheet 1 Data to Worksheet 2 | Excel Programming |