View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benjamin.mangelinckx@telindus.be is offline
external usenet poster
 
Posts: 3
Default 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