This is far beyond my scope and I have over 2700 entries that I need to do this for and really hoping someone here can help me with this.
Table 1 - Resides in A9:Z2780
<tbody>
</tbody>
The above table I need Cell A To contain D+H+ some sort of vlookup of CELL I from the table 2 below. Example
Cell A in the sample above would make 5 new lines.. And cell E. Because CELL I in this example = "A" we use S, M, L, XL, XXL
CELL A CELL E
1043-110160ES PORT JACKET GREEN SMALL
1043-110160EM PORT JACKET GREEN MEDIUM
1043-110160EL PORT JACKET GREEN LARGE
1043-110160EXL PORT JACKET GREEN XLARGE
1043-110160EXXL PORT JACKET GREEN XXLARGE
And still copy all the data from the others cells From A to Z
Table 2 - J4:T7
<tbody>
</tbody><colgroup><col><col span="10"></colgroup>
Table 1 - Resides in A9:Z2780
A | B | C | D | E | F | G | H | I |
JACKETS | JACKETS | 1043-11001 | PORT JACKET | GREEN | 60E | A | ||
<tbody>
</tbody>
The above table I need Cell A To contain D+H+ some sort of vlookup of CELL I from the table 2 below. Example
Cell A in the sample above would make 5 new lines.. And cell E. Because CELL I in this example = "A" we use S, M, L, XL, XXL
CELL A CELL E
1043-110160ES PORT JACKET GREEN SMALL
1043-110160EM PORT JACKET GREEN MEDIUM
1043-110160EL PORT JACKET GREEN LARGE
1043-110160EXL PORT JACKET GREEN XLARGE
1043-110160EXXL PORT JACKET GREEN XXLARGE
And still copy all the data from the others cells From A to Z
Table 2 - J4:T7
A | S | M | L | XL | XXL | |||||
B | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 36 | 38 | 40 |
C | O/S | S/M | L/XL | |||||||
D | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
<tbody>
</tbody><colgroup><col><col span="10"></colgroup>