Hello and thanks for looking
I am trying to loop through a spreadsheet looking in column 3 for DC01, DC02, DC03...ect
and in between the DCXX, in column B, i am also looking for EDITION,
i need to make a list with the DCXX, followed by each instance of EDiTION and the 8 columns of data
listed in between each instance if DCXX
the DCXX goes from DC01 to DC250
i can only find one or the other
i cant seem to start looking for EDITION when i find DCXX,
then stop looking for EDITION when i find the next DCXX
I can only get all of the DCXX listed, Or all of the EDITIONS listed
Thank you very much
it should look like the following when its done, only a much longer list
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 64px"> <col style="WIDTH: 73px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I am trying to loop through a spreadsheet looking in column 3 for DC01, DC02, DC03...ect
and in between the DCXX, in column B, i am also looking for EDITION,
i need to make a list with the DCXX, followed by each instance of EDiTION and the 8 columns of data
listed in between each instance if DCXX
the DCXX goes from DC01 to DC250
i can only find one or the other
i cant seem to start looking for EDITION when i find DCXX,
then stop looking for EDITION when i find the next DCXX
I can only get all of the DCXX listed, Or all of the EDITIONS listed
Thank you very much
it should look like the following when its done, only a much longer list
| A | B | C | D | E | F | G | H |
2 | DC01 | | | | | | | |
3 | | EDITION | 1 | 1 | 1 | 2 | 1 | 1 |
4 | | EDITION | 3 | 625 | 4 | 640 | 1266 | 12504 |
5 | DC02 | | | | | | | |
6 | | EDITION | 5 | 5 | 1 | 2 | 5 | 5 |
7 | | EDITION | 3 | 10 | 1 | 10 | | 10 |
8 | | EDITION | 4 | 279 | 4 | 285 | 565 | 5584 |
9 | | EDITION | 5 | 605 | 1 | 625 | 1231 | 12101 |
10 | DC03 | | | | | | | |
11 | | EDITION | 2 | 155 | 19 | 164 | 320 | 3119 |
12 | | EDITION | 5 | 437 | 8 | 451 | 889 | 8748 |
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 64px"> <col style="WIDTH: 73px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4