Okay everyone, so im after suggestions for this process here are is the scope and requirements.
1. i need to perform a runnign 7 day average for a graph of a chosen month from a series of maintenance data. i.e for may days 01-06 will need to incorporate the last few days of april. now i have got the chosen month working i.e all automated etc, so that code works well.
2.what im after is some way to choose the month you want then choose the previous month, and then it automatically runs the other macro in the previous and chosen month (populates all the data) then copies the last 7 days into the chosen month for the average.
i was thinking something like this to choose the file:
but how do you get it to specify the filename for the second month and then do the calcs etc on it? thanks
Bookmarks