A | B | C | D | E | |
38 | No | OP | MO | Txt | Co |
39 | 112254 | 10 | 04 FSR | Yeah | ABB |
40 | 114554 | 20 | 04 FLB | Whatever | ABB |
41 | 144754 | 10 | 04 BBA | Etc | Claptrap |
42 | 112266 | 40 | 04 KKT | Blah | Claptrap |
43 | 123457 | 15 | 04 JJF | Blah | Claptrap |
44 | 111365 | 10 | 04 MMN | Blah | Gardner |
45 | 125845 | 100 | 04 FSR | Blah | Gardner |
46 | 124655 | 50 | 04 HHY | Blah | Zeus |
<tbody>
</tbody>
I am struggling with the code needed to format a table by a common variable. The table looks like the above and is compiled in Co alphabetic order. I'm needing a macro that will split the table into common Co, put the Coname above with column titles, insert some cells below (N2:Y6) followed by a page break so it looks like this:
A | B | C | D | E | |
37 | ABB | ||||
38 | No | OP | MO | Txt | Co |
39 | 112254 | 10 | 04 FSR | Yeah | ABB |
40 | 114554 | 20 | 04 FLB | Whatever | ABB |
41 | (Paste N2:Y6 here) | ||||
42 | |||||
43 | |||||
44 | |||||
45 | (Page break below) | ||||
46 | Claptrap | ||||
47 | No | OP | MO | Txt | Co |
48 | 144754 | 10 | 04 BBA | Etc | Claptrap |
49 | 112266 | 40 | 04 KKT | Blah | Claptrap |
50 | 123457 | 15 | 04 JJF | Blah | Claptrap |
51 | (Paste N2:Y6 here) | ||||
52 | |||||
53 | |||||
54 | (Page break below) | ||||
55 | Gardner | ||||
56 | No | OP | MO | Txt | Co |
57 | 111365 | 10 | 04 MMN | Blah | Gardner |
58 | 125845 | 100 | 04 FSR | Blah | Gardner |
59 | (Paste N2:Y6 here) | ||||
60 | |||||
61 | |||||
62 | (Page break below) | ||||
63 | Zeus | ||||
64 | No | MO | OP | Txt | Co |
65 | 124655 | 50 | 04 HHY | Blah | Zeus |
66 | (Paste N2:Y6 here) | ||||
67 | |||||
68 | |||||
69 | |||||
70 | (Page break below) |
<tbody>
</tbody>
Jake.