+ Reply to Thread
Results 1 to 3 of 3

Creating a Complex Series of Column Headers

  1. #1
    Registered User
    Join Date
    06-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Creating a Complex Series of Column Headers

    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.

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Creating a Complex Series of Column Headers

    Maybe something like:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,446

    Re: Creating a Complex Series of Column Headers

    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.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1