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