+ Reply to Thread
Results 1 to 5 of 5

Find most recent date in Column Headings in a Range, insert new column and heading

  1. #1
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    Find most recent date in Column Headings in a Range, insert new column and heading

    Hi,

    I have a 2 groups of column headings with a different month and year in each heading so

    1st Group of columns range
    Columns AJ through AX
    Column Heading example "Expense Ratio February 2013......next Column over is "Expense Ratio March 2013"

    2nd Group of columns range AY though CE
    Column Heading example "Capital Balance February 2013......next Column over is "Capital Balance March 2013"

    Each new month I need to add a new Expense Ratio column after the most recent expense ratio Column. (i.e. Find "Expense Ratio March 2013" and I need to add a column after that with heading "Expense Ratio April 2013"

    Same thing for Capital Balance - add a new Capital Balance column after the most recent Capital Balance Column. (i.e. Find "Capital Balance March 2013" and I need to add a column after that for "Expense Ratio April 2013"

    Because the ranges keep changing month over month, how do i do this. If anyone can help with this code, would be greatly appreciated!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Find most recent date in Column Headings in a Range, insert new column and heading

    Hello mikey3580,

    It would be helpful to have a sample workbook when doing the code development. Can you post one?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    Re: Find most recent date in Column Headings in a Range, insert new column and heading

    Thank you!!!

    See Columns AJ though CB in attachment

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Find most recent date in Column Headings in a Range, insert new column and heading

    Hello mikey3580,

    The headings in the workbook you posted don't match with the headings in your first post. Are the workbook headings the same as the ones in the workbook you are using?

  5. #5
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    Re: Find most recent date in Column Headings in a Range, insert new column and heading

    This is the actual workbook I am using. I was thinking of changing the headings in any case for ease and clarity. Whatever is easier I can adapt the headings. Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find the most recent date in a column based on a name in a different column
    By Tamarissa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2014, 10:10 AM
  2. [SOLVED] Find column heading then sort the sheet off that column
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 10:00 AM
  3. Find a column heading then sorting the sheet off that column
    By Cluv in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2011, 12:16 AM
  4. Insert/Add new column/s with heading name
    By Pankaj Sonawane in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2010, 03:40 AM
  5. Find Column heading and then Delete entire column
    By Kobayashi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2005, 05:05 PM

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