I am really struggling with this one. Any help would be appreciated. Some pre works leaves me with a list of people who have travelled. I would like to be able to create seperate workbooks that use the same header as within the data extract. rows 1-6 and then all the data with the same "cost centre owners" (column ad) information within each seperate workbook. So the example
<tbody>
</tbody> would produce 4 workbooks called "a johnson", "msmith", "K Klien", "Richard James" with 1, 5, 5,1, rows of data respectively. These workbooks would be saved sepeartely in a specified location.
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | aa | ab | ac | ad | |||
1 | ||||||||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||||||||
6 | Client Number | Name | cost centre | Staff ID | Div | ATB | Reason | Class travel | Invoice Date | Invoice number | date of travel | lead name | no of passenger | product name | product code | supplier | routing | Fare | Fare2 | Fare3 | savings | Savings | Declined | Nett | Vat | Gross | Narrative | Hotel Beds | PNR Date | product type | cost centre owner | |
7 | 4673 | Company Name | 1234 | x | 25/02/14 | 1 | 25/02 | a johnson | ||||||||||||||||||||||||
8 | 4673 | Company Name | 1234 | x | 25/02/14 | 123 | 25/02 | m smith | ||||||||||||||||||||||||
9 | 4673 | Company Name | 1234 | x | 26/02/14 | 114 | 26/02 | k klien | ||||||||||||||||||||||||
10 | 4673 | Company Name | 1234 | x | 27/02/14 | 115 | 27/07 | m smith | ||||||||||||||||||||||||
11 | 4673 | Company Name | 1234 | x | 25/02/14 | 116 | 25/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
12 | 4673 | Company Name | 1234 | x | 25/02/14 | 117 | 25/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
13 | 4673 | Company Name | 1234 | x | 01/02/14 | 118 | 01/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
14 | 4673 | Company Name | 1234 | x | 03/02/14 | 119 | 03/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
15 | 4673 | Company Name | 1324 | x | 03/02/14 | 120 | 03/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
16 | 4673 | Company Name | 1234 | x | 03/02/14 | 121 | 03/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
17 | 4673 | Company Name | 1234 | x | 03/02/14 | 122 | 03/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
18 | 4673 | Company Name | 1324 | x | 7/02/14 | 123 | 07/02 |
<colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody> | ||||||||||||||||||||||||
<tbody>
</tbody>