In one worksheet I need to show lists of codes in specific cells to show their placement on a hazard table, which is a 6×4 table (From left to right on top: F, E, D, C, B, A. From top to bottom on the left, I, II, III, IV). In another worksheet, I have 3 columns: the first column contains all the codes (GR.1.1.1.1 for example), the second with manually inputted Roman numeral values “I, II, III, or IV”, and the third with manually inputted letters “A, B, C, D, E, or F” that determine which cell the codes should be added to in the table.
Can you use a macro to copy and paste all the codes from one worksheet to their appropriate cell in the table in another worksheet and make each cell organize the codes into a list? I have used VBA lightly, but I have more experience in MATLAB.
I have shown the table with some codes manually typed in to show how it should look.
