Greg
Thanks for suggestion i am sending data as per ur suggestion.

Example data from Data worksheet
Date ref no opening amount pending amount due date overdue days
Auto Comp. Blank Row
15-Apr-04 80037 -1469 -1469 15-Apr-04 641
30-Apr-04 80065 -1609 -1609 30-Apr-04 626
15-May-04 80090 -86 -86 15-May-04 611

Pink & Pink Blank Row
15-Aug-05 MAA001000506 -3173.6 -1189.6 15-Aug-05 154
31-Aug-05 MAA001070506 -10076.7 -10076.7 31-Aug-05 138
31-Oct-05 MAA001580506 -357.05 -357.05 31-Oct-05 77
15-Nov-05 MAA001770506 -79.34 -79.34 15-Nov-05 62


Current output data from Output Report
Worksheet

Party Data ref no opening amount pending amount due date overdue days
Auto Comp. Blank row
15-Apr-04 80037 -1469 -1469 15-Apr-04 641
30-Apr-04 80065 -1609 -1609 30-Apr-04 626
15-May-04 80090 -86 -86 15-May-04 611
Total -3164 -3164

Pink & Pink Blank row
15-Aug-05 MAA001000506 -3173.6 -1189.6 15-Aug-05 154
31-Aug-05 MAA001070506 -10076.7 -10076.7 31-Aug-05 138
31-Oct-05 MAA001580506 -357.05 -357.05 31-Oct-05 77
15-Nov-05 MAA001770506 -79.34 -79.34 15-Nov-05 62

Total -14202. -12218.42

Desired output data from Output Report worksheet
Date ref no opening amount pending amount due date overdue days
Auto Comp. Blank Row
15-Apr-04 80037 -1469 -1469 15-Apr-04 641
30-Apr-04 80065 -1609 -1609 30-Apr-04 626
15-May-04 80090 -86 -86 15-May-04 611
Total -3164 -3164
Pink & Pink Blank Row
15-Aug-05 MAA001000506 -3173.6 -1189.6 15-Aug-05 154
31-Aug-05 MAA001070506 -10076.7 -10076.7 31-Aug-05 138
31-Oct-05 MAA001580506 -357.05 -357.05 31-Oct-05 77
15-Nov-05 MAA001770506 -79.34 -79.34 15-Nov-05 62
Total -14202. -12218.42
pls look into it and if you want file i send you
****al

"Greg Wilson" wrote:

Sorry, I don't understand your request. I thought that was what you wanted. I
suggest that you:

1. List some simple example data under the heading "Example data from Data
worksheet:"
2. List the current output data (that results from the macro as it is
currently written) under the heading "Current output data from Output Report
worksheet:"
3. List the desired output data under the heading "Desired output data from
Output Report worksheet:"
4. The macro appears to be written to account for gaps in the date data in
column A of sheet Data due to grouping of data. I suggest that you either
avoid gaps in the example data or indicate gaps with the word "blank".

Regards,
Greg

"****al shah" wrote:

thanks Greg Wilson for reply. It working but i want Party name to be there
above date. with this code it delete party name I want party name also.

Is this possible.

thanks

****al