Results 1 to 2 of 2

Updating Forecast/Actual Sheet With a Macro

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2014
    Posts
    23

    Updating Forecast/Actual Sheet With a Macro

    So I am trying to make a macro that will update monthly forecast data to what the actual production/consumption data was. The production/consumption numbers come in separate workbooks (i.e. "Jan14", "Feb14") and need to be linked to the 'Book' main file. The path needs to the Jan14 needs to come into the 'Book' file, not just the values. I would like to be able to just have a button above each month that will just automatically load that month's data when it becomes available.

    Thanks, you guys are great!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Area Chart with Actual and Forecast Data
    By lespaul00 in forum Excel General
    Replies: 0
    Last Post: 07-02-2012, 11:53 AM
  2. Forecast against Actual
    By leviathan86 in forum Excel General
    Replies: 1
    Last Post: 05-23-2012, 03:02 PM
  3. Dashboard - Actual Vs Budget and Re-forecast
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 10-05-2011, 05:36 AM
  4. How To Calculate Variance B/W Actual and Forecast Data
    By Cherish2007 in forum Excel General
    Replies: 1
    Last Post: 03-28-2007, 05:01 PM
  5. Changing Forecast Data to Actual
    By Brian Hearty via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 04:21 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