October 4, 2022
I currently have a moving average equation working properly with the ability to change the intervals of which is finds the average. This is being done on a month to month basis (separate worksheet for each month in one workbook) for volumes. However, we need a moving average that will cross over each month. For example, right now I cannot find the moving 7 day average starting back from 10/2/2022 because of the separated worksheets. I have a master dashboard worksheet in the workbook and I was able to use "Paste Link" for each month to pull the total volume per day into this master sheet, but I cannot get my moving average to work because it pulls from the last cell (#368) and upwards, which currently are all zero/blank. I think it is because of the "paste link" function as my other worksheets are able to calculate despite how many rows are blank because it pulls from the last entered value.
To add- this excel document is being run in a Microsoft Teams page which not have the power consolidate functions.
July 16, 2010
Welcome to our forum! You're right, you should not have your data in separate sheets for each month. You can use Power Query to gather the data into a single tabular layout as it should be. Your formulas should work from there.