1. Johnny C

    Linked cells ignoring the folder where the files with the same name are stored in different folders

    I have a load of models that are stored in a folder for each day. Last thing at night I create the next day's folder and copy all the files into it from that day. This is because we need to be able to track where and when changes were made. There might be hundreds of changes made in a day, too...
  2. Johnny C

    Excel 365 ProPlus - saved links giving 'old' values?

    I have a model that generates charts for PowerPoint. The values in the table for the chart are linked to another workbook. Each day the models are copied to a new folder with the date in, as we need to keep a close audit trail. So the value in one of the cells could be ='F:\3 Year...
  3. C

    Macro to built final file from 3 different files

    Hello Excel masters :smile: I need your help in order to develop a final file (CustomerForecast) from 3 different files with some restrictions. The final file should have the below format. The columns "FactType" and "Unit" should have always the same values. <tbody> Depot/StoreFormat...
  4. C

    Macro that takes data from 3 files and create a final file with restrictions

    Hello Excel masters :) I need your help in order to develop a final file (CustomerForecast) from 3 different files with some restrictions. The final file should have the below format. The columns "FactType" and "Unit" should have always the same values. <tbody> Depot/StoreFormat Product...
  5. C


    Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be. <colgroup><col><col span="12"></colgroup><tbody> Monthly Data Jan Feb Mar Apr May Jun...
  6. B

    Sumproduct Array

    Hey Guys, I have a set of data with data and projects, in the format below: [Row 4, starting column F] Jan Feb Mar etc. [Column B, starting row 6] Project A, Project B I'm trying to sum all the forecast for for a project, based on the previous month's forecast - so i can compare with what's...
  7. U

    Help with Pulling in List to copy Dates

    I have a set number of dates that I need to forecast. Some of the months I have dont always have a Forecast but I want to be able to at least post a 0 still in that date. What I need is to be able to use a list of parts IE 301080.01 301081.01 301082.01 301083.01 Etc ( this parts will be...
  8. B

    Formula to VBV - weeks of cover

    HI All, Thank you for your help in advance.Im really struggle to translate one formula to the code. Below formula is calculating weeks of stock cover based on deliveries and demand. Unforgettably it have plenty of "if" slowing down the report. Im looking to translate this to VBA code. Is anyone...
  9. C

    Forecast Match and Index in VBA

    I'm trying to simplify some really long formulas in my model by creating some custom functions. I've cleaned up a lot but there's this forecast with offset and match that's throwing me off. here's the formula =FORECAST(AE1264,OFFSET('Data Table Dynamic'!$AC$4,MATCH(AE1264,'Data Table...
  10. A

    Forecasting Quantity in Sales

    I have a product for which units sold in May is 12420, Jun is 1200, and Jul is 12400. How can i forecast that how many units will be sold for the next 12 months?.
  11. R

    Need Help on creating a forecast for completion date

    Hi Everyone! I was looking for some help on creating a completion date forecast. Here are some details of my inquiry Total Callable Records: 60,000 Total Agents: 34 WorkHours/day: 8 hrs (weekends are not included) Start Date: 8/5/2019 I want to determine the date of completion with an...
  12. C

    Sales Pacing Forecasting - Weekly report changing figures

    Good Morning, I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below. *** Put a date in a cell...
  13. M

    Bill Of Material Forecast Based on Timing of Material Change

    Hi All, I am looking for help regarding forecasting future material requirement from finished goods forecast. I have this set up currently in excel with a few index and sumproduct formulas. However the material code within the finished goods can change depending on promotion etc, at various...
  14. W

    Overwrite data

    Hi there I am trying to create a macro/code that will overwrite data each day when a new file arrives I have a spreadsheet that has a daily forecast for the next month where each day has 48 half hours/rows and 28 columns (including the column for the date/period i.e. dd/mm/yyyy hh:mm). This...
  15. M

    Forecasting and what if parameters in Power Bi Desktop

    Hi Everyone, I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...
  16. gheyman

    Forecasting Linear?

    If I have two Quantities and two Unit Prices, is the a formula that will forecast another qty? Qty 100 = $25.00 Qty 500 = 10.50 Is there a formula that would forecast Qty 300 or any other quantity I enter that is between 100 and 500 (Using a straight line)? Thanks
  17. S

    Forecast analysis - How to add percentage increase to the chart and/or pivot table?

    I've managed to successfully create a Forecast line chart. It has produced a table including forecast values, which is great. However, I'd really like to know what % increase it's working on? How would I go about adding this column to the Forecast table?
  18. S

    Mean Reversion Calculation

    Hello, First off, appreciate any help as I a have been banging my head on this for some time. I want to see if there is any guidance on how to do a mean reversion forecast in excel. The data points are very simple and are linked below for your reference...
  19. K

    VBA to simulate double-clicking a cell

    I know it sounds weird...but I have some complicated code that has MANY conditions for when I double click a cell in a range. I want a code that will run the code associated with the double-clicking of the cells automatically without actually double clicking. to sum up (I think): I have an...
  20. D

    Record data based on a time stamp

    Hi All, I control a monthly sales forecast - sales people enter their forecast for the month but then can amend this at 2 dates in the month (approx 10th and the 20th), it is then fixed. I need to track the changes they make; example. Cell B1 they enter £100,000 for June On the 10th they may...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...