@ Dear All,
I have a worksheet named "payments" containing the data of payments made to clients.
A1==B1==C1==D1==E1
Sr No==Name of Party == Date ==Cheque No== Amount
1 Religare Finvest Ltd 20/08/2012 =516997 552.00
2 RCIL 12/03/2012 =120815 864.00
3 HDFC ERGO General Indurance Co Ltd 31/12/2012 =439112 29,121.75
4 HDFC ERGO General Indurance Co Ltd 31/12/2012 =439113 29,121.75
5 Valmiki Aashram Dharmartha 19/01/2013 =439471 3,100.00
6 E E EUDD 5 Noida 27/02/2013 =440066 1,796.00
7 The New India Assurance Co Ltd 20/03/2013 =120951 28,125.00
8 Airtel 02/07/2013 =499386 16,092.00
9 The New India Assurance Co Ltd 04/07/2013 =499392 42,391.00
10 The New India Assurance Co Ltd 04/07/2013 =499394 21,078.00
11 RCIL A/c RIS2368479587 14/08/2013 =339845 698.00
12 Ultratech Cement Ltd 08/10/2012 =334670 277,380.00
13 Rohit Shakyawar 29/08/2011 =872068 30,500.00
14 Rajesh Kumar 29/08/2011 =872059 6,500.00
15 Jain sons 08/01/2012 =334681 6,486.00
16 Parveen Kumar 11/02/2012 =3522 6,500.00
17 Abdesh Anu 12/02/2012 =334508 1,384.00
18 Rohit Singh 05/03/2012 =334914 7,500.00
19 Harpreet Singh CHD 05/05/2012 =334618 2,300.00
20 Shiv Dayal Ray 05/07/2012 =307595 8,000.00
Here, the data to be sorted datewise separately for each month in another worksheet called "monthwise data". For example, if any payment is given in the month of March 2013, it should display from 1st day to 31st day from January to December and like wise. The worksheet "Payment" will remain only for data entry.
Please help me to do this.
VDS
I have a worksheet named "payments" containing the data of payments made to clients.
A1==B1==C1==D1==E1
Sr No==Name of Party == Date ==Cheque No== Amount
1 Religare Finvest Ltd 20/08/2012 =516997 552.00
2 RCIL 12/03/2012 =120815 864.00
3 HDFC ERGO General Indurance Co Ltd 31/12/2012 =439112 29,121.75
4 HDFC ERGO General Indurance Co Ltd 31/12/2012 =439113 29,121.75
5 Valmiki Aashram Dharmartha 19/01/2013 =439471 3,100.00
6 E E EUDD 5 Noida 27/02/2013 =440066 1,796.00
7 The New India Assurance Co Ltd 20/03/2013 =120951 28,125.00
8 Airtel 02/07/2013 =499386 16,092.00
9 The New India Assurance Co Ltd 04/07/2013 =499392 42,391.00
10 The New India Assurance Co Ltd 04/07/2013 =499394 21,078.00
11 RCIL A/c RIS2368479587 14/08/2013 =339845 698.00
12 Ultratech Cement Ltd 08/10/2012 =334670 277,380.00
13 Rohit Shakyawar 29/08/2011 =872068 30,500.00
14 Rajesh Kumar 29/08/2011 =872059 6,500.00
15 Jain sons 08/01/2012 =334681 6,486.00
16 Parveen Kumar 11/02/2012 =3522 6,500.00
17 Abdesh Anu 12/02/2012 =334508 1,384.00
18 Rohit Singh 05/03/2012 =334914 7,500.00
19 Harpreet Singh CHD 05/05/2012 =334618 2,300.00
20 Shiv Dayal Ray 05/07/2012 =307595 8,000.00
Here, the data to be sorted datewise separately for each month in another worksheet called "monthwise data". For example, if any payment is given in the month of March 2013, it should display from 1st day to 31st day from January to December and like wise. The worksheet "Payment" will remain only for data entry.
Please help me to do this.
VDS
