Hi John

I noticed you help tariqnaz2005 with a macro to insert 2 rows on each change in customer name and put a total for all amounts.

Could you advise as to how to adapt this macro to suit my data.

Many thanks
Tacknow