R
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
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