+ Reply to Thread
Results 1 to 2 of 2

How do I change column data based on dynamic (rolling) dates?

  1. #1
    Registered User
    Join Date
    07-24-2006
    Posts
    2

    How do I change column data based on dynamic (rolling) dates?

    I'm trying to set up a spreadsheet that is a 2 year rolling forecast. The raw data is either imported or manually entered into separate worksheets. I then take this data and summarise in another worksheet. The problem I have is that the forecast summary worksheet is static & I need it to be dynamic.

    For example,

    Month: Jan Feb Mar Apr May
    Sales: 50 75 80 85 90

    As the month changes then the rolling forecast should look like:

    Month: Feb Mar Apr May Jun
    Sales: 75 80 85 90 100
    and so on ......

    I can get the month value to dynamically change when the month changes, but I cannot get the data in the columns to alter in line with the month.

    Does anyone know how I can tie the summarised data to the rolling month?

    FB

  2. #2
    Forum Contributor
    Join Date
    12-04-2003
    Posts
    360
    write a macro to either hide or delete the month gone.
    cells(row,col).entirecolumn.delete

    then insert the next month at the end of the period by using fill.

    It should be easy enough to record this if you're not experienced with coding.

+ Reply to Thread

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