• 470K Members
• 5,842 Online
• 568K Conversations

## Create table from 3 types of variables within a cell that contains a dynamic alpha numeric range

Occasional Visitor

# Create table from 3 types of variables within a cell that contains a dynamic alpha numeric range

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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies