Creating a Complex Series of Column Headers

**t-sett** · 06-01-2012, 08:45 PM

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.

**StevenM** · 06-01-2012, 09:17 PM

Maybe something like:

Please Login or Register  to view this content.

**MarvinP** · 06-01-2012, 09:24 PM

Use the Modulo function and append it using the Column() numbers.
Something like

Please Login or Register  to view this content.

in cell A1. Then pull it to the right and see if it is what you want.
Play with it a bit so it works for you exactly like you want.
Then copy row 1 and paste over it using values only to remove the formulas.