+ Reply to Thread
Results 1 to 4 of 4

Listing months in columns based on user defined start month

  1. #1
    Registered User
    Join Date
    06-18-2007
    MS-Off Ver
    2007
    Posts
    77

    Listing months in columns based on user defined start month

    i need to create column headings that display the 12 months. the first column would be a FY starting month selected by the user in a data validation field. columns to the right would then populate with sequential months, one month per column. FY starting month can be any of the 12 months. my trouble is restarting back to January when the start date is something other than January. Actual years do not need to be noted, only the months.

    i could have the user select the fiscal ending month instead of the fiscal starting month if that makes it any easier.

    Thanks.

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    1,454

    Re: Listing months in columns based on user defined start month

    in b2 and drag it across

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Booşathì

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,389

    Re: Listing months in columns based on user defined start month

    With the dropdown in A1, I used this formula in B1 copied to the right

    =IF(LEN(A1),INDEX(Months,MOD(MATCH(A1, Months,0),12)+1),"")
    Months is a defined named range on sheet2. See attached
    Attached Files Attached Files
    ChemistB
    My 2¢

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    06-18-2007
    MS-Off Ver
    2007
    Posts
    77

    Re: Listing months in columns based on user defined start month

    ChemistB solution works perfect. Thanks.

+ 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] Need formula to calucalte based on start month # and duration # of months
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2014, 05:59 PM
  2. [SOLVED] Averaging a user input defined range based on values in columns
    By smit.etha in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-14-2014, 02:21 AM
  3. user defined macro to replace certain characters in a string based on user input
    By whatappears in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 06:25 PM
  4. User Defined Function does not appear on Function listing
    By H.P.Hoeie, Norway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 06:30 AM
  5. User defined function to count pay days in current month.
    By dbmathis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2005, 09: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