Results 1 to 12 of 12

Continue series after a break

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Continue series after a break

    I'm writing a program to make projections. Part 1 looks at history, part 2 looks at future.

    In part 1, Cells D2,E2, and F2 say "June, July, August" this month, next month they'll say "June, July, August, September". Following the months is the Total column. Then we come to part 2. To the right of the total column I'd like the continuation of the series for my projection (3 months only). So, for this month, G2 is Total, H2, I2, and J2 should be "September, October, November". Next month they all shift one to the right.

    I know how to do the shift to the right, but how do I continue the series?

    Any help is greatly appreciated.
    Last edited by jomili; 09-28-2010 at 01:16 PM.

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