May 24 2019 01:50 AM
I dont know how best to explain my scenario.
Imported data will have 3 types of variables in each cell. A range has to be identified. labels assigned to cells based on that range, populate cells in that range, and change color of cells in that range.
-Type 1 used to identify fill color of cell identified in Type 2($PI=RED,$TI= NO COLOR, $SI=Green)
-Type 2 Range of cells dynamically identified, 2 characters long. The first character will be a letter the second will be number. Letters start with A, numbers start with 1 and end in 0. examples A1-A0, A2-A2, A1-C4. each grouping of data will have different set of ranges
-Type 3 will be the data for each cell example C=1 C=Y6DP C=RV3S
I will have to have Multiple tables on one sheet so i can't use the cells row and column as the Type 2 data ie.. type 2 data of A3-G4 can't refer to cells A3-G4 on the sheet.
Here is what outcome should look like
INIT | CLASS | GROUP1DAY | CLASS | GROUP1NITE |
A1 | 1 | $TI(A1),C=1 | 1 | $PI(I1-I5) |
A2 | 1 | $TI(A2-A2),C=1 | 5 | $PI(F7-H6) |
A3 | 3 | $TI(A3-A4),C=3 | C | $TI(A1),C=1 |
A4 | 3 | $TI(A5-A6),C=Y6DP | C | $TI(A2-A2),C=5 |
A5 | Y6DP | $TI(A7-A8),C=R | Y6DP | $TI(A3-A4),C=C |
A6 | Y6DP | $TI(A9-B9),C=C | Y6DP | $TI(A5-A6),C=Y6DP |
A7 | R | $TI(C0-C4),C=Y6DP | R | $TI(A7-A8),C=R |
A8 | R | $TI(C5-D0),C=JN | R | $TI(A9-B9),C=C |
A9 | C | $TI(D1-D3),C=F | C | $TI(C0-C4),C=Y6DP |
B0 | C | $TI(D4-D6),C=7 | C | $TI(C5-D0),C=JN |
B1 | C | $TI(D7-D8),C=G | C | $TI(D1-D3),C=XZFWI7 |
INIT | CLASS | GROUP2DAY | ||
A1 | 1 | $PI(I1-I5) | ||
A2 | 1 | $TI(A1),C=1 | ||
A3 | 3 | $TI(A2-A2),C=1 | ||
A4 | 3 | $TI(A3-A4),C=3 |