I am trying to make 2772 unique column headings where one element resets every 7 columns and another element changes every 462 columns. Currently, I have a column header (“A_1”, “A_2”, “A_3”) every 7 columns. I want to insert new unique heading between the existing ones (“A_1”, A_1_1”, “A_1_2”, “A_1_3”,…, “A_1_6”, “A_2”, “A_2_1”,… “A_2_6”,…”A_66_6”, “B_1”, “B_1_1”, …, “F_66_6”). I think I can make a macro with a relative reference and only have to run the macro 396 times.
Does anyone know a better way?
For a better understanding of what I am trying to do, please see the attached file Creating a Complex Series of Column Headers - Excel Forum Help.xlsx. I have filled in the first few columns as a model.
Bookmarks