Split a Worksheet into Multiple Worksheets by a name

D

Darker1973

New Member
Joined
Jun 4, 2014
Messages
3
Hi,
I have a rather large company salary review tool cols A - BQ which I have built and needs to be split by Reviewer (col L).
The document has over 4869 lines of data but I want to keep all other functionality ie macro buttons and so on.
Basically it should be a copy worksheet, and then cut by reviewer. Can anyone help me with something, somehow to do this with some code? cheers

[TABLE="width: 6063"]
<colgroup><col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="124" style="width: 93pt; mso-width-source: userset; mso-width-alt: 4534;"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="186" style="width: 140pt; mso-width-source: userset; mso-width-alt: 6802;"> <col width="232" style="width: 174pt; mso-width-source: userset; mso-width-alt: 8484;"> <col width="206" style="width: 155pt; mso-width-source: userset; mso-width-alt: 7533;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="293" style="width: 220pt; mso-width-source: userset; mso-width-alt: 10715;"> <col width="220" style="width: 165pt; mso-width-source: userset; mso-width-alt: 8045;"> <col width="230" style="width: 173pt; mso-width-source: userset; mso-width-alt: 8411;"> <col width="286" style="width: 215pt; mso-width-source: userset; mso-width-alt: 10459;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;"> <col width="267" style="width: 200pt; mso-width-source: userset; mso-width-alt: 9764;"> <col width="262" style="width: 197pt; mso-width-source: userset; mso-width-alt: 9581;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="174" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6363;"> <col width="252" style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;"> <col width="205" style="width: 154pt; mso-width-source: userset; mso-width-alt: 7497;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="2"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="12"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="3"> <col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="2"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" span="2"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="4"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="3"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="285" style="width: 214pt; mso-width-source: userset; mso-width-alt: 10422;" span="2"> <tbody>[TR]
[TD="width: 65, bgcolor: transparent, align: left"]
-- removed inline image ---
<tbody> [TD="width: 65, bgcolor: #F2F2F2"] [/TD]
</tbody>
[/TD]
[TD="width: 124, bgcolor: #F2F2F2"] [/TD]
[TD="width: 54, bgcolor: #F2F2F2"] [/TD]
[TD="width: 186, bgcolor: #F2F2F2"] [/TD]
[TD="width: 232, bgcolor: #F2F2F2"] [/TD]
[TD="width: 206, bgcolor: transparent, align: left"]
-- removed inline image ---
<tbody> [TD="width: 206, bgcolor: #F2F2F2"] [/TD]
</tbody>
[/TD]
[TD="width: 70, bgcolor: #F2F2F2"] [/TD]
[TD="width: 293, bgcolor: #F2F2F2"] [/TD]
[TD="width: 220, bgcolor: #F2F2F2"] [/TD]
[TD="width: 230, bgcolor: #F2F2F2"] [/TD]
[TD="width: 286, bgcolor: #F2F2F2"] [/TD]
[TD="width: 128, bgcolor: #F2F2F2"] [/TD]
[TD="width: 132, bgcolor: #F2F2F2"] [/TD]
[TD="width: 71, bgcolor: #F2F2F2"] [/TD]
[TD="width: 95, bgcolor: #F2F2F2"] [/TD]
[TD="width: 267, bgcolor: #F2F2F2"] [/TD]
[TD="width: 262, bgcolor: #F2F2F2"] [/TD]
[TD="width: 83, bgcolor: #F2F2F2"] [/TD]
[TD="width: 174, bgcolor: #F2F2F2"] [/TD]
[TD="width: 252, bgcolor: #F2F2F2"] [/TD]
[TD="width: 205, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 95, bgcolor: transparent, align: left"]
-- removed inline image ---
<tbody> [TD="width: 95, bgcolor: #F2F2F2"] [/TD]
</tbody>
[/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 86, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 91, bgcolor: #F2F2F2"] [/TD]
[TD="width: 110, bgcolor: transparent, align: left"]
-- removed inline image ---
<tbody> [TD="width: 110, bgcolor: #F2F2F2"] [/TD]
</tbody>
[/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 89, bgcolor: #F2F2F2"] [/TD]
[TD="width: 89, bgcolor: #F2F2F2"] [/TD]
[TD="width: 110, bgcolor: #F2F2F2"] [/TD]
[TD="width: 106, bgcolor: #F2F2F2"] [/TD]
[TD="width: 100, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 88, bgcolor: transparent, align: left"]
-- removed inline image ---
<tbody> [TD="width: 88, bgcolor: #F2F2F2"] [/TD]
</tbody>
[/TD]
[TD="width: 96, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 82, bgcolor: #F2F2F2"] [/TD]
[TD="width: 285, bgcolor: #F2F2F2"] [/TD]
[TD="width: 285, bgcolor: #F2F2F2"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #95B3D7"] Total Budget [/TD]
[TD="bgcolor: #95B3D7"] [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #95B3D7, colspan: 2"] Total Spend To Date [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #D9D9D9, colspan: 8"] Target Incentives not Actual Award to Compare Opportunity of Incentives Year on Year [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #95B3D7, colspan: 2"] Remaining Spend [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[/TR]
[TR]
[TD="width: 65, bgcolor: #D9D9D9"]ID[/TD]
[TD="width: 124, bgcolor: #D9D9D9"]HRD[/TD]
[TD="width: 54, bgcolor: #D9D9D9"]Payroll[/TD]
[TD="width: 186, bgcolor: #D9D9D9"]Surname[/TD]
[TD="width: 232, bgcolor: #D9D9D9"]First Name[/TD]
[TD="width: 206, bgcolor: #D9D9D9"]BU-1[/TD]
[TD="width: 70, bgcolor: #D9D9D9"]LPS Business[/TD]
[TD="width: 293, bgcolor: #D9D9D9"]Business Name[/TD]
[TD="width: 220, bgcolor: #D9D9D9"]Unit[/TD]
[TD="width: 230, bgcolor: #D9D9D9"]Organization[/TD]
[TD="width: 286, bgcolor: #D9D9D9"] Supervisor[/TD]
[TD="width: 128, bgcolor: #FCD5B4"]1st Level
Salary Reviewer [/TD]
[TD="width: 132, bgcolor: #FCD5B4"]2nd Level
Salary Reviewer[/TD]
[TD="width: 71, bgcolor: #D9D9D9"]Actual No. Hours worked[/TD]
[TD="width: 95, bgcolor: #D9D9D9"]Start Date[/TD]
[TD="width: 267, bgcolor: #D9D9D9"]Job Title[/TD]
[TD="width: 262, bgcolor: #D9D9D9"]Career Grade Name[/TD]
[TD="width: 83, bgcolor: #D9D9D9"]Career Level[/TD]
[TD="width: 174, bgcolor: #D9D9D9"]Job Classification[/TD]
[TD="width: 252, bgcolor: #D9D9D9"]2013 Performance Rating[/TD]
[TD="width: 205, bgcolor: #7030A0"] 2014 Performance Rating [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]Salary before
Last Change £ [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]Last
Salary Change Date [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]Salary
% Change[/TD]
[TD="width: 95, bgcolor: #D9D9D9"]Current Salary
 £ [/TD]
[TD="width: 82, bgcolor: #7030A0"]INPUT
 Promotion wef 1-7-2014 Y/N [/TD]
[TD="width: 82, bgcolor: #7030A0"]PLEASE CHECK
 New Grade wef 1-7-2014[/TD]
[TD="width: 82, bgcolor: #DA9694"]TOWERS MATCHING CODE[/TD]
[TD="width: 82, bgcolor: #DA9694"]LQ
Salary[/TD]
[TD="width: 82, bgcolor: #DA9694"]Med
 Salary[/TD]
[TD="width: 82, bgcolor: #DA9694"]UQ
 Salary[/TD]
[TD="width: 82, bgcolor: #DA9694"]LQ
Salary - 2013 Aged Data [/TD]
[TD="width: 82, bgcolor: #DA9694"]Med
 Salary - 2013 Aged Data [/TD]
[TD="width: 82, bgcolor: #DA9694"]UQ
 Salary - 2013 Aged Data [/TD]
[TD="width: 82, bgcolor: #DA9694"]LQ
Target Total Comp[/TD]
[TD="width: 82, bgcolor: #DA9694"]Med
 Target Total Comp[/TD]
[TD="width: 82, bgcolor: #DA9694"]UQ
 Target Total Comp[/TD]
[TD="width: 82, bgcolor: #DA9694"]LQ
Target Total Comp - 2013 Aged Data [/TD]
[TD="width: 82, bgcolor: #DA9694"]Med
 Target Total Comp- 2013 Aged Data [/TD]
[TD="width: 82, bgcolor: #DA9694"]UQ
 Target Total Comp- 2013 Aged Data [/TD]
[TD="width: 86, bgcolor: #D9D9D9"]Current Car Allowance
 £ [/TD]
[TD="width: 82, bgcolor: #8DB4E2"]New Car Allowance July
Y/N [/TD]
[TD="width: 82, bgcolor: #7030A0"]Car Allowance
1-7-2014 [/TD]
[TD="width: 82, bgcolor: #8DB4E2"]Increase Car Allowance July
£ [/TD]
[TD="width: 91, bgcolor: #8DB4E2"]Current Full time
Annual Salary
£ [/TD]
[TD="width: 110, bgcolor: #95B3D7"]2013 Salary Market Data Positioning
If Available [/TD]
[TD="width: 82, bgcolor: #7030A0"]INPUT
Salary Increase July 2014
£ [/TD]
[TD="width: 82, bgcolor: #7030A0"]INPUT
Salary Increase July 2014
% [/TD]
[TD="width: 89, bgcolor: #95B3D7"]
New Salary July 2014
£ [/TD]
[TD="width: 89, bgcolor: #95B3D7"]Salary Inc
% [/TD]
[TD="width: 110, bgcolor: #95B3D7"]New Salary Market Data Positioning
 If Available [/TD]
[TD="width: 106, bgcolor: #7030A0"]INPUT
 Discretionary Bonus July 2014
£ [/TD]
[TD="width: 100, bgcolor: #95B3D7"]Salary & Discretionary Bonus Spend 2014
 £ [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]2013
PPP / Sales Target % [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]2013
PPP / Sales Target £ [/TD]
[TD="width: 82, bgcolor: #95B3D7"]2014
PPP Target % [/TD]
[TD="width: 82, bgcolor: #95B3D7"]2014
PPP Target
£ [/TD]
[TD="width: 82, bgcolor: #95B3D7"]2014 Sales Target
% [/TD]
[TD="width: 82, bgcolor: #95B3D7"]2014 Sales Target
£ [/TD]
[TD="width: 82, bgcolor: #D9D9D9"]2013 Long Term Incentive
£ [/TD]
[TD="width: 82, bgcolor: #95B3D7"] 2014 Target Long Term Incentive
£ [/TD]
[TD="width: 88, bgcolor: #D9D9D9"]Previous FTE Target Total Comp (sal+car+
 bonus+LTI) [/TD]
[TD="width: 96, bgcolor: #95B3D7"] New FTE Target Total Comp (sal+car+PPP/Sales+LTI) [/TD]
[TD="width: 82, bgcolor: #95B3D7"] Change in Target Total Comp % [/TD]
[TD="width: 82, bgcolor: #95B3D7"] o [/TD]
[TD="width: 82, bgcolor: #95B3D7"] NEW Total Target Comp Positioning [/TD]
[TD="width: 285, bgcolor: #F2F2F2"]Reward/HR Comment[/TD]
[TD="width: 285, bgcolor: #7030A0"]Manager / HR Comment[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]14896[/TD]
[TD="bgcolor: transparent"]TEST[/TD]
[TD="bgcolor: white"]TEST[/TD]
[TD="bgcolor: white"]Surname[/TD]
[TD="bgcolor: white"]First Name[/TD]
[TD="bgcolor: white"]BU-1[/TD]
[TD="bgcolor: white"]LPS Business[/TD]
[TD="bgcolor: white"]Business Name[/TD]
[TD="bgcolor: white"]Unit[/TD]
[TD="bgcolor: white"]Organization[/TD]
[TD="bgcolor: white"] Supervisor[/TD]
[TD="bgcolor: #FCD5B4"]Robert Parker[/TD]
[TD="bgcolor: #FCD5B4"] [/TD]
[TD="bgcolor: white"]37.5[/TD]
[TD="bgcolor: white"]04-Jan-2000[/TD]
[TD="bgcolor: white"]Job Title[/TD]
[TD="bgcolor: white"]Career Grade Name[/TD]
[TD="bgcolor: white"]Level 5[/TD]
[TD="bgcolor: transparent"]Job Classification[/TD]
[TD="bgcolor: transparent"]3 - Meets expectations[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]01/07/2013[/TD]
[TD="bgcolor: white"]0.00%[/TD]
[TD="bgcolor: transparent"] £ 100 [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"]-[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]Y[/TD]
[TD="bgcolor: #7030A0"] £ 1,000 [/TD]
[TD="bgcolor: white"] £ 900 [/TD]
[TD="bgcolor: #8DB4E2"] £ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]0.0%[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ - [/TD]
[TD="bgcolor: transparent"]10.0%[/TD]
[TD="bgcolor: transparent"] £ 10 [/TD]
[TD="bgcolor: transparent"]10%[/TD]
[TD="bgcolor: transparent"] £ 10 [/TD]
[TD="bgcolor: transparent"]0.0%[/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: white"] £ 210 [/TD]
[TD="bgcolor: #95B3D7"] £ 1,110 [/TD]
[TD="bgcolor: white"]428.57%[/TD]
[TD="bgcolor: transparent"] £ 900 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"]302615[/TD]
[TD="bgcolor: transparent"]TEST[/TD]
[TD="bgcolor: white"]TEST[/TD]
[TD="bgcolor: white"]Scally[/TD]
[TD="bgcolor: white"]Damian[/TD]
[TD="bgcolor: white"]BU-1[/TD]
[TD="bgcolor: white"]LPS Business[/TD]
[TD="bgcolor: white"]Business Name[/TD]
[TD="bgcolor: white"]Unit[/TD]
[TD="bgcolor: white"]Organization[/TD]
[TD="bgcolor: white"] Supervisor[/TD]
[TD="bgcolor: #FCD5B4"]Robert Parker[/TD]
[TD="bgcolor: #FCD5B4"] [/TD]
[TD="bgcolor: white"]37.5[/TD]
[TD="bgcolor: white"]30-Apr-2012[/TD]
[TD="bgcolor: white"]Job Title[/TD]
[TD="bgcolor: white"]Career Grade Name[/TD]
[TD="bgcolor: white"]Level 5[/TD]
[TD="bgcolor: transparent"]Job Classification[/TD]
[TD="bgcolor: transparent"]2 - Exceeds expectations[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]01/07/2013[/TD]
[TD="bgcolor: white"]0.00%[/TD]
[TD="bgcolor: transparent"] £ 100 [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"]-[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]N[/TD]
[TD="bgcolor: #7030A0"] £ - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #8DB4E2"] £ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]0.0%[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ - [/TD]
[TD="bgcolor: transparent"]5.0%[/TD]
[TD="bgcolor: transparent"] £ 5 [/TD]
[TD="bgcolor: transparent"]5%[/TD]
[TD="bgcolor: transparent"] £ 5 [/TD]
[TD="bgcolor: transparent"]0.0%[/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: white"] £ 205 [/TD]
[TD="bgcolor: #95B3D7"] £ 105 [/TD]
[TD="bgcolor: white"]-48.78%[/TD]
[TD="bgcolor: transparent"]-£ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"]314953[/TD]
[TD="bgcolor: transparent"]TEST[/TD]
[TD="bgcolor: white"]TEST[/TD]
[TD="bgcolor: white"]Auer[/TD]
[TD="bgcolor: white"]Jens[/TD]
[TD="bgcolor: white"]BU-1[/TD]
[TD="bgcolor: white"]LPS Business[/TD]
[TD="bgcolor: white"]Business Name[/TD]
[TD="bgcolor: white"]Unit[/TD]
[TD="bgcolor: white"]Organization[/TD]
[TD="bgcolor: white"] Supervisor[/TD]
[TD="bgcolor: #FCD5B4"]Robert Parker[/TD]
[TD="bgcolor: #FCD5B4"] [/TD]
[TD="bgcolor: white"]40.0[/TD]
[TD="bgcolor: white"]01-Oct-2013[/TD]
[TD="bgcolor: white"]Job Title[/TD]
[TD="bgcolor: white"]Career Grade Name[/TD]
[TD="bgcolor: white"]Level 5[/TD]
[TD="bgcolor: transparent"]Job Classification[/TD]
[TD="bgcolor: transparent"] - [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]01/10/2013[/TD]
[TD="bgcolor: white"]0.00%[/TD]
[TD="bgcolor: transparent"] £ 100 [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"]-[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]N[/TD]
[TD="bgcolor: #7030A0"] £ - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #8DB4E2"] £ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]0.0%[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ - [/TD]
[TD="bgcolor: transparent"]2.0%[/TD]
[TD="bgcolor: transparent"] £ 2 [/TD]
[TD="bgcolor: transparent"]2%[/TD]
[TD="bgcolor: transparent"] £ 2 [/TD]
[TD="bgcolor: transparent"]0.0%[/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: white"] £ 202 [/TD]
[TD="bgcolor: #95B3D7"] £ 102 [/TD]
[TD="bgcolor: white"]-49.50%[/TD]
[TD="bgcolor: transparent"]-£ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"]306766[/TD]
[TD="bgcolor: transparent"]TEST[/TD]
[TD="bgcolor: white"]TEST[/TD]
[TD="bgcolor: white"]Basol[/TD]
[TD="bgcolor: white"]Kenan[/TD]
[TD="bgcolor: white"]BU-1[/TD]
[TD="bgcolor: white"]LPS Business[/TD]
[TD="bgcolor: white"]Business Name[/TD]
[TD="bgcolor: white"]Unit[/TD]
[TD="bgcolor: white"]Organization[/TD]
[TD="bgcolor: white"] Supervisor[/TD]
[TD="bgcolor: #FCD5B4"]Robert Parker[/TD]
[TD="bgcolor: #FCD5B4"] [/TD]
[TD="bgcolor: white"]40.0[/TD]
[TD="bgcolor: white"]15-Sep-2012[/TD]
[TD="bgcolor: white"]Job Title[/TD]
[TD="bgcolor: white"]Career Grade Name[/TD]
[TD="bgcolor: white"]Level 5[/TD]
[TD="bgcolor: transparent"]Job Classification[/TD]
[TD="bgcolor: transparent"]3 - Meets expectations[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]01/07/2013[/TD]
[TD="bgcolor: white"]0.00%[/TD]
[TD="bgcolor: transparent"] £ 100 [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"]-[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]N[/TD]
[TD="bgcolor: #7030A0"] £ - [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #8DB4E2"] £ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ 100 [/TD]
[TD="bgcolor: white"]0.0%[/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[TD="bgcolor: white"] £ - [/TD]
[TD="bgcolor: transparent"]2.0%[/TD]
[TD="bgcolor: transparent"] £ 2 [/TD]
[TD="bgcolor: transparent"]2%[/TD]
[TD="bgcolor: transparent"] £ 2 [/TD]
[TD="bgcolor: transparent"]0.0%[/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: transparent"] £ - [/TD]
[TD="bgcolor: white"] £ 202 [/TD]
[TD="bgcolor: #95B3D7"] £ 102 [/TD]
[TD="bgcolor: white"]-49.50%[/TD]
[TD="bgcolor: transparent"]-£ 100 [/TD]
[TD="bgcolor: white"] - [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: #7030A0"] [/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Hi Darker,
Please be sure to run this on a copy of your file as I have NOT tested this macro. This is a variation of something that I use all the time.

Code: 
Sub XL_Split_by_Reviewer()


ActiveSheet.Name = "Complete"
LastRow = Cells(Rows.Count, 1).End(xlUp).Row


'   ***** Robert Parker *****


Rows("1:1").AutoFilter
Range("L:L").AutoFilter Field:=12, Criteria1:=Array("Robert Parker"), Operator:=xlFilterValues
 
Range("A1:AV" & LastRow).SpecialCells(xlCellTypeVisible).Select
Application.Application.CutCopyMode = False
Selection.Copy


With ActiveWorkbook.Sheets
    .Add After:=Sheets(Sheets.Count)
End With
ActNm = ActiveSheet.Name
ActiveSheet.Name = "Robert Parker"
Sheets("Parker").Paste


Sheets("Complete").Select


'   ***** John Doe *****


ActiveSheet.ShowAllData
Range("L:L").AutoFilter Field:=12, Criteria1:=Array("John Doe"), Operator:=xlFilterValues
 
Range("A1:AV" & LastRow).SpecialCells(xlCellTypeVisible).Select
Application.Application.CutCopyMode = False
Selection.Copy


With ActiveWorkbook.Sheets
    .Add After:=Sheets(Sheets.Count)
End With
ActNm = ActiveSheet.Name
ActiveSheet.Name = "John Doe"
Sheets("John Doe").Paste


 
End Sub

What this does is filters based on the name in Column L, copies visible cells only and pastes into a new worksheet. I hope this works for you.
Cheers!
 
Upvote 0
MrsPen said:
Hi Darker,
Please be sure to run this on a copy of your file as I have NOT tested this macro. This is a variation of something that I use all the time.

Code: 
Sub XL_Split_by_Reviewer()


ActiveSheet.Name = "Complete"
LastRow = Cells(Rows.Count, 1).End(xlUp).Row


'   ***** Robert Parker *****


Rows("1:1").AutoFilter
Range("L:L").AutoFilter Field:=12, Criteria1:=Array("Robert Parker"), Operator:=xlFilterValues
 
Range("A1:AV" & LastRow).SpecialCells(xlCellTypeVisible).Select
Application.Application.CutCopyMode = False
Selection.Copy


With ActiveWorkbook.Sheets
    .Add After:=Sheets(Sheets.Count)
End With
ActNm = ActiveSheet.Name
ActiveSheet.Name = "Robert Parker"
Sheets("Parker").Paste


Sheets("Complete").Select


'   ***** John Doe *****


ActiveSheet.ShowAllData
Range("L:L").AutoFilter Field:=12, Criteria1:=Array("John Doe"), Operator:=xlFilterValues
 
Range("A1:AV" & LastRow).SpecialCells(xlCellTypeVisible).Select
Application.Application.CutCopyMode = False
Selection.Copy


With ActiveWorkbook.Sheets
    .Add After:=Sheets(Sheets.Count)
End With
ActNm = ActiveSheet.Name
ActiveSheet.Name = "John Doe"
Sheets("John Doe").Paste


 
End Sub

What this does is filters based on the name in Column L, copies visible cells only and pastes into a new worksheet. I hope this works for you.
Cheers!
Click to expand...

/
Thanks for this - is there a way to take in multiple names - ie 100 and loop through rather than a named name - ?
 
Upvote 0
Hi,

It certainly works for the filtering and sets up a new worksheet named Robert Parker but then I receive "Subscript out of Range",(my columns go from A:BQ - which I have amended in the code)

I also need this to split by whatever the name that is in L -it may be any name - is this possible?

Thanks again

Darker

 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
pulling data from one chart to another
Replies
1
Views
810
jb00976
J
T
  • Question Question
VBA to launch userform by selecting a cell
2
Replies
10
Views
2K
Logit
Logit
H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
983
AlanY
A
N
  • Question Question
excel macro to split data into multiple worksheets based on conditions worksheet
Replies
4
Views
4K
Fluff
Fluff

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top