software

I have a sheet exported from ACT that we need to get information from into
another Agency management system.
The sheet has columns that include customer name, contact info, and notes.
The number of notes (rows) is different with each customer. What I would
like to do is extract notes for a specific customer, and create a new
workbook with it.
I believe there might be a way if I subtotal on each change in company, but
I can't find it. Any help is GREATLY appreciated.
See example below -
Before -
Date |Company |Notes
01/01/2004| #1 |Steve is a great guy
01/10/2005| #1 |He Really is
01/25/2006| #2 |Any help or advice
01/30/2006| #2 |would be great
02/25/2006| #2 |Thanks!

So from that I would like to be able to automatically create 2 seperate
workbooks, one named #1 with the first 2 rows (Not including header), and one
named #2 with the last 3.
Thanks in advance -
-ShaneDebra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box.

Debra's site:
www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

And Ron de Bruin's easyfilter.
www.rondebruin.nl/easyfilter.htmYou may be able to modify them to use separate workbooks--I think as they're
written, they create separate sheets in the same workbook.

WSI wrote:
gt;
gt; I have a sheet exported from ACT that we need to get information from into
gt; another Agency management system.
gt; The sheet has columns that include customer name, contact info, and notes.
gt; The number of notes (rows) is different with each customer. What I would
gt; like to do is extract notes for a specific customer, and create a new
gt; workbook with it.
gt; I believe there might be a way if I subtotal on each change in company, but
gt; I can't find it. Any help is GREATLY appreciated.
gt; See example below -
gt; Before -
gt; Date |Company |Notes
gt; 01/01/2004| #1 |Steve is a great guy
gt; 01/10/2005| #1 |He Really is
gt; 01/25/2006| #2 |Any help or advice
gt; 01/30/2006| #2 |would be great
gt; 02/25/2006| #2 |Thanks!
gt;
gt; So from that I would like to be able to automatically create 2 seperate
gt; workbooks, one named #1 with the first 2 rows (Not including header), and one
gt; named #2 with the last 3.
gt; Thanks in advance -
gt; -Shane

--

Dave Peterson

Thanks Dave - I will try them and post back how they work.
Shane

quot;Dave Petersonquot; wrote:

gt; Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
gt; may be sufficient right out of the box.
gt;
gt; Debra's site:
gt; www.contextures.com/excelfiles.html
gt;
gt; Create New Sheets from Filtered List -- uses an Advanced Filter to create
gt; separate sheet of orders for each sales rep visible in a filtered list; macro
gt; automates the filter. AdvFilterRepFiltered.xls 35 kb
gt;
gt; or
gt;
gt; Update Sheets from Master -- uses an Advanced Filter to send data from
gt; Master sheet to individual worksheets -- replaces old data with current.
gt; AdvFilterCity.xls 55 kb
gt;
gt; And Ron de Bruin's easyfilter.
gt; www.rondebruin.nl/easyfilter.htm
gt;
gt;
gt; You may be able to modify them to use separate workbooks--I think as they're
gt; written, they create separate sheets in the same workbook.
gt;
gt; WSI wrote:
gt; gt;
gt; gt; I have a sheet exported from ACT that we need to get information from into
gt; gt; another Agency management system.
gt; gt; The sheet has columns that include customer name, contact info, and notes.
gt; gt; The number of notes (rows) is different with each customer. What I would
gt; gt; like to do is extract notes for a specific customer, and create a new
gt; gt; workbook with it.
gt; gt; I believe there might be a way if I subtotal on each change in company, but
gt; gt; I can't find it. Any help is GREATLY appreciated.
gt; gt; See example below -
gt; gt; Before -
gt; gt; Date |Company |Notes
gt; gt; 01/01/2004| #1 |Steve is a great guy
gt; gt; 01/10/2005| #1 |He Really is
gt; gt; 01/25/2006| #2 |Any help or advice
gt; gt; 01/30/2006| #2 |would be great
gt; gt; 02/25/2006| #2 |Thanks!
gt; gt;
gt; gt; So from that I would like to be able to automatically create 2 seperate
gt; gt; workbooks, one named #1 with the first 2 rows (Not including header), and one
gt; gt; named #2 with the last 3.
gt; gt; Thanks in advance -
gt; gt; -Shane
gt;
gt; --
gt;
gt; Dave Peterson
gt;