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.