+ Reply to Thread
Results 1 to 2 of 2

Autofill Months Based on User Input

  1. 07-08-2014, 02:51 PM #1
    jalex627
    jalex627 is offline
    Registered User
    Join Date
    07-08-2014
    Location
    Pittsburgh
    MS-Off Ver
    MAC 2011 14.3.9
    Posts
    1

    Autofill Months Based on User Input

    Hi, not sure if this question has been answered or not but I searched and couldn't find it. I would like to autofill cells based on the month typed in by a user in a different cell. For example, if the user types in January to cell A1, I want cells A2 through 48 to fill in all the upcoming months for the next 4 years. Or if they typed in June to A1, I would want A2 through A48 to fill in starting with July and ending with May. This seems like something simple but I'm really struggling. Still a beginner so the simplest answer would be great unless that's not possible. Thanks
    Reply With QuoteRegister To Reply
  2. 07-08-2014, 03:24 PM #2
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Autofill Months Based on User Input

    Paste this into A2 and then copy down.

    =CHOOSE(MOD(MATCH(A1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),12)+1,"January","February","March","April","May","June","July","August","September","October","November","December")
    Last edited by GeneralDisarray; 07-08-2014 at 03:26 PM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Input Form with number of line items based on user input
    By j_gideon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 02:54 PM
  2. Automatic Formula Input Based on User Input Using a Macro
    By Drayloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 12:10 PM
  3. VBA Autofill with user input
    By bibleguy125 in forum Excel General
    Replies: 0
    Last Post: 03-02-2012, 11:59 AM
  4. Using text box input to lookup number and replace based on user input into new column
    By harl3y412 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2011, 03:15 PM
  5. [SOLVED] formula or VBA - would like to autofill cells based on start date and # of months
    By jsr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2006, 11:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1