Hello,
I have a spreadsheet that contains several columns similar to the below:
<tbody>
</tbody>
What I would like to be able to do is the following:
1. Create different workbooks (This example would result in 3 workbooks) that contain the same data where Reg Code (2 characters always) is the same.
2. Each workbook would contain the rows of information where Reg Code is the same; however, I would NOT like to include any rows containing "00" in the Area Code field.
3. Lines 1 and 2 would be copied over each time.
4. Create each file name based on "[Category]_[Sub Category]_MMMYYYY.xlsx"
TIA!
I have a spreadsheet that contains several columns similar to the below:
A | B | C | D | E | F | G | |
1 | Report Date: | 6/22/18 | |||||
2 | First Name | Last Name | Category | Sub Category | Reg Code | Dist Code | Area Code |
3 | Jon | Doe | Fruit | Apple | 11 | 000 | 00 |
4 | Jane | Doe | Fruit | Apple | 11 | 001 | 00 |
5 | Jack | Doe | Fruit | Apple | 11 | 001 | 01 |
6 | Mary | Doe | Fruit | Apple | 11 | 002 | 00 |
7 | Jasper | Test | Fruit | Apple | 11 | 002 | 01 |
8 | Veronica | Test | Fruit | Orange | 12 | 000 | 00 |
9 | Angel | Test | Fruit | Orange | 12 | 001 | 00 |
10 | Jim | Doe | Fruit | Orange | 12 | 001 | 01 |
11 | Jess | Grass | Veggie | Carrot | 13 | 000 | 00 |
12 | June | High | Veggie | Carrot | 13 | 001 | 00 |
13 | Jen | One | Veggie | Carrot | 13 | 001 | 01 |
<tbody>
</tbody>
What I would like to be able to do is the following:
1. Create different workbooks (This example would result in 3 workbooks) that contain the same data where Reg Code (2 characters always) is the same.
2. Each workbook would contain the rows of information where Reg Code is the same; however, I would NOT like to include any rows containing "00" in the Area Code field.
3. Lines 1 and 2 would be copied over each time.
4. Create each file name based on "[Category]_[Sub Category]_MMMYYYY.xlsx"
TIA!
Last edited: