Results 1 to 4 of 4

Rolling finance chart. Move Data over 1 row when month changes

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Rolling finance chart. Move Data over 1 row when month changes

    Hello, ExcelForum.

    I have searched the internet high and low and I am currently troubleshooting this myself, but I would really appreciate any assistance that can be provided.

    This is going to be a 13 month chart for finances and should be able to accomplish two tasks

    1. When the most recent month, March (E1) changes to April, Cell D1 should become March, Cell C1 should become February, and Jan should be dropped entirely.

    2. When the months roll over, the financial data corresponding to that month needs to move with it. Everything from $E$1:$E$34 should move to $D$1:$D$34

    I really appreciate any help that can be provided. I am running Microsoft Excel 2013. Please let me know if more information is needed.

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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