Hi All:
Can you please tell me if there is a macro that will copy at each change in
Customer name and paste into a new worksheet. For example, if I have over
32,000 lines of data each subtotalled by Customer Name and Sales $, how can I
get a macro to copy each group and paste into a new worksheet. I have about
60 different customers so wanted to try to reduce some of the manual copy and
paste that is necessary.

Thanks to all for your response.

Nikki