I'm trying to find a way to create new worksheets, and populate it
with values, everytime a specific column value changes. I've sorted
the master worksheet by driver name. Now, I'd like a routine or
add-in that creates a new worksheet everytime the driver's name
changes. Worksheet name should be driver's name, and column headers
(row 1) should be included at the top of each worksheet. There are 15
or so columns of data, and that data should be copied over as well.
It sort of reminds me of the Subtotal routine, but instead of
subtotals or page breaks between groups, I'd like a new worksheet for
each manager.

I'm running Excel XP. I need to distribute in Excel because most of
our driver's don't have Access or Snapshot Viewer installed.

I've searched and searched the newsgroups, the Microsoft KB, as well
as a few great Excel sites and haven't found anything that addresses
this problem.

Any ideas or pointers are appreciated.

Gary
www.storkoccasions.com

You may want to run a macro whenever you need the extraction.

Debra Dalgleish's has some code that does this kind of thing:

http://www.contextures.com/excelfiles.html

There are a couple of files you may want to steal from:

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

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

Gary wrote:

I'm trying to find a way to create new worksheets, and populate it
with values, everytime a specific column value changes. I've sorted
the master worksheet by driver name. Now, I'd like a routine or
add-in that creates a new worksheet everytime the driver's name
changes. Worksheet name should be driver's name, and column headers
(row 1) should be included at the top of each worksheet. There are 15
or so columns of data, and that data should be copied over as well.
It sort of reminds me of the Subtotal routine, but instead of
subtotals or page breaks between groups, I'd like a new worksheet for
each manager.

I'm running Excel XP. I need to distribute in Excel because most of
our driver's don't have Access or Snapshot Viewer installed.

I've searched and searched the newsgroups, the Microsoft KB, as well
as a few great Excel sites and haven't found anything that addresses
this problem.

Any ideas or pointers are appreciated.

Gary
www.storkoccasions.com

--

Dave Peterson