Automatic new worksheet creation at each change of value in a first worksheet
Hi,
I have a worksheet with all my supplier invoices.
In colum "A", I have the supplier name.
In all other columns I have the details of the invoices.
I want to have a macro that sort the sheet on column A, then
automatically create a worksheet per supplier with all invoices.
This mean at each change of supplier name, I want a new worksheet with
the invoices of this supplier.
I wonder if you could give me some hints ...
Thanks a lot
Benjamin
|