+ Reply to Thread
Results 1 to 3 of 3

Automatic or dynamic rolling month

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    56

    Automatic or dynamic rolling month

    Dear sir,

    I would like to set the automatic rolling month when i select month at dropdown list and this will show at C5 and need to cell at the right hand side auto change month to Jul, Aug, ... Dec, Jan, Feb.

    and at left handside show the previous month.

    Rolling month.xlsx


    Best regards,

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Automatic or dynamic rolling month

    Hi,

    Please see the attached file.
    Attached Files Attached Files

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Automatic or dynamic rolling month

    Try this.....

    In C5
    Please Login or Register  to view this content.
    and in D5
    Please Login or Register  to view this content.
    and then copy across.
    And custom format as mmm.

    Is this what you are trying to achieve?
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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] Turn Dynamic Horizontal Chart into 12-month rolling
    By robbrown in forum Excel General
    Replies: 7
    Last Post: 12-27-2015, 05:22 PM
  2. 3 month rolling - dynamic
    By Armitage2k in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2014, 09:26 AM
  3. Rolling 12 Month Dynamic Calculation
    By bapswarrior in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-29-2013, 04:37 PM
  4. How to automatic rolling data based on the change of the month
    By littleYS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-29-2012, 10:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1