kelz_dunks4life
New Member
- Joined
- Sep 13, 2014
- Messages
- 5
Good Morning All,
I was wondering if there's a way to take an Excel file that can be split into multiple files by multiple criteria. I tried searching the forum, but couldn't find anything [or maybe I missed it].
Please see the example below.
The file needs to be split into multiple workbooks by the 'PT_Name' that ONLY contains information from 'UC_BC' that is either 171, 172, 173, or174.
For instance:
DAILY CENSUS MASTER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
And split certain contents into multiple files saved by the PT Name:
ONE,PLAYER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
TWO,PLAYER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
THREE,PLAYER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>FOUR,PLAYER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Is this something possible? I've suggested using a Pivot Table, but I'd rather find out from any of you if this is something that cannot be done. I hope I was clear and I appreciate your help.
Kels
I was wondering if there's a way to take an Excel file that can be split into multiple files by multiple criteria. I tried searching the forum, but couldn't find anything [or maybe I missed it].
Please see the example below.
The file needs to be split into multiple workbooks by the 'PT_Name' that ONLY contains information from 'UC_BC' that is either 171, 172, 173, or174.
For instance:
DAILY CENSUS MASTER.XLS
DT OF SVC | STN | RM/BED | UB_CD | CUR AC | ADM DT | LOS | PT NAME | NXT REV|DATE | MRN | ACCT# | DOB | SEX | AGE | ADM DX | SVC | TYPE | ATTEND MD | TOTAL CHGS | FC | INS1 | POLICY#1 | APPROVAL#1 | INS2 | POLICY#2 | APPROVAL#2 | INS3 | POLICY#3 | APPROVAL#3 | TOT|DAYS |
9/12/2014 | 3E | E326-A | 123 | K | 9/8/2014 | 4 | COUNT, DOES NOT | 9/9/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $40,244.20 | HS | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E335-A | 123 | K | 9/8/2014 | 4 | COUNT, DOES NOT | 9/15/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $42,512.40 | 1 | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E338-A | 123 | K | 9/10/2014 | 2 | COUNT, DOES NOT | 9/12/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $10,687.25 | AE | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E344-A | 171 | K | 7/11/2014 | 63 | ONE, PLAYER | 7/15/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $784,728.79 | E | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E340-A | 171 | K | 8/6/2014 | 37 | ONE, PLAYER | 9/13/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $463,681.65 | 12 | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E336-A | 172 | J | 9/11/2014 | 1 | TWO,PLAYER | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $2,964.25 | UH | XYZ | 123456789 | |||||||||
9/12/2014 | 3E | E343-A | 173 | K | 9/8/2014 | 4 | THREE,PLAYER | 9/9/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $28,745.45 | KA | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E325-A | 173 | K | 9/7/2014 | 5 | THREE,PLAYER | 9/12/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $37,135.10 | 11 | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E342-A | 174 | K | 8/15/2014 | 28 | FOUR, PLAYER | 8/19/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $279,051.21 | HS | XYZ | 123456789 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
And split certain contents into multiple files saved by the PT Name:
- PT Name that only contains UB_CD as 171, 172, 173, and 174
ONE,PLAYER.XLS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
TWO,PLAYER.XLS
DT OF SVC | STN | RM/BED | UB_CD | CUR AC | ADM DT | LOS | PT NAME | NXT REV|DATE | MRN | ACCT# | DOB | SEX | AGE | ADM DX | SVC | TYPE | ATTEND MD | TOTAL CHGS | FC | INS1 | POLICY#1 | APPROVAL#1 | INS2 | POLICY#2 | APPROVAL#2 | INS3 | POLICY#3 | APPROVAL#3 | TOT|DAYS |
9/12/2014 | 3E | E336-A | 172 | J | 9/11/2014 | 1 | TWO,PLAYER | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $2,964.25 | UH | XYZ | 123456789 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
THREE,PLAYER.XLS
DT OF SVC | STN | RM/BED | UB_CD | CUR AC | ADM DT | LOS | PT NAME | NXT REV|DATE | MRN | ACCT# | DOB | SEX | AGE | ADM DX | SVC | TYPE | ATTEND MD | TOTAL CHGS | FC | INS1 | POLICY#1 | APPROVAL#1 | INS2 | POLICY#2 | APPROVAL#2 | INS3 | POLICY#3 | APPROVAL#3 | TOT|DAYS |
9/12/2014 | 3E | E343-A | 173 | K | 9/8/2014 | 4 | THREE,PLAYER | 9/9/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $28,745.45 | KA | XYZ | 123456789 | 0 | |||||||
9/12/2014 | 3E | E325-A | 173 | K | 9/7/2014 | 5 | THREE,PLAYER | 9/12/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $37,135.10 | 11 | XYZ | 123456789 | 0 | |||||||
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
DT OF SVC | STN | RM/BED | UB_CD | CUR AC | ADM DT | LOS | PT NAME | NXT REV|DATE | MRN | ACCT# | DOB | SEX | AGE | ADM DX | SVC | TYPE | ATTEND MD | TOTAL CHGS | FC | INS1 | POLICY#1 | APPROVAL#1 | INS2 | POLICY#2 | APPROVAL#2 | INS3 | POLICY#3 | APPROVAL#3 | TOT|DAYS |
9/12/2014 | 3E | E342-A | 174 | K | 8/15/2014 | 28 | FOUR, PLAYER | 8/19/2014 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | 9999999 | NIC | IP | KELZ_DUNKS4LIFE | $279,051.21 | HS | XYZ | 123456789 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Is this something possible? I've suggested using a Pivot Table, but I'd rather find out from any of you if this is something that cannot be done. I hope I was clear and I appreciate your help.
Kels