I have a workbook which is a list of sales transactions. Column A is a
unique customer reference number which identifies the customer. Each
customer has anything from 1 to hundreds of transactions.

I'm trying to write a macro to export all transactions for each customer,
into a new workbook for each unique customer number, so if I run the macro
on my original workbook with 50 customers purchases, I get 50 workbooks each
with an individual customers purchase history...

I don't really know where to start. Help gratefully recieved.

Rich