Move data to different sheets

[Ronny Hamida]

It's me again! I have a strange one that might already
exist.

Here's an example of a spreadsheet that I'm working with:

Col A | Col B | Title | Title Code
Data1 | Data 2 | CSE3 | 12345
Data3 | Data 4 | CSE3 | 12345
Data5 | Data 6 | PIN2 | 54321
Data7 | Data 8 | PIN2 | 77777


I usually take this data and do a subtotal on it to give
me a count for each time the "Title Code" changes, however
I'd like to move the entire row into a new worksheet (not
new Excel file) with the worksheet having the name of its
Title. For instance, in the above example, there would be
three new worksheets titled, "CSE3," "PIN2," and "PIN2
(2)" because this second PIN2 title has a different Title
Code.

Also the data that matches would be moved into each
matching worksheet. So the "CSE3" sheet would have the
first two rows of data moved into it, the first PIN2 would
have the "54321" row, and the second PIN2 would have
the "77777" row.

At the same time, if at all possible, can the header be
copied to the beginning of each of the worksheets?

Thank you in advance!
Ronny

 

[Dave Peterson]

I'd use a helper column to concatenate the two title fields into one.

=C2&"--"&d2
(copied down)

Then I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

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