Hello,
Here is my setup. I have one Master Table containing data from multiple departments. I have 5 queries, one for each department, that sort my data. My goal is to take the average of one column from each query and export them to an excel spreadsheet.
The spreadsheet would look something like this:
Date | Avg Department #1 | Avg Department #2 | etc etc etc.
I'm looking at bob larson's website but I'm not well versed in VBA coding. I've also tried to put all 5 averages onto one query but it's just too complicated of a procedure. Any more than 3 of the 5 values causes the code to run forever.
Any help would be much appreciated. Thanks!
-Dane
Edit: I forgot to mention that I also want to do this process once a week, every Monday. This means when the file exports, I need excel to insert the data into a different row each time.
Here is my setup. I have one Master Table containing data from multiple departments. I have 5 queries, one for each department, that sort my data. My goal is to take the average of one column from each query and export them to an excel spreadsheet.
The spreadsheet would look something like this:
Date | Avg Department #1 | Avg Department #2 | etc etc etc.
I'm looking at bob larson's website but I'm not well versed in VBA coding. I've also tried to put all 5 averages onto one query but it's just too complicated of a procedure. Any more than 3 of the 5 values causes the code to run forever.
Any help would be much appreciated. Thanks!
-Dane
Edit: I forgot to mention that I also want to do this process once a week, every Monday. This means when the file exports, I need excel to insert the data into a different row each time.
