LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Worksheet Calculation when Worksheet Name Changes Sabre472 Excel Worksheet Functions 1 April 9th 09 06:17 PM
need help with creation of an investment analysis worksheet Brucer New Users to Excel 2 October 15th 07 06:13 PM
Action Item Worksheet Creation Kevin M[_2_] Excel Worksheet Functions 0 February 26th 07 09:16 PM
Automatic updating of a rollup worksheet when a new worksheet is a Marc A. Excel Worksheet Functions 1 August 7th 06 07:49 PM
Using this Automatic Resizing Macro with Worksheet Change [email protected] Excel Discussion (Misc queries) 0 December 19th 05 03:57 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"