VBA AVERAGE Across Multiple Excel files

hareendra

New Member
Joined
Feb 24, 2016
Messages
3
I am working on my company project to calculate average of daily production efficiency maintain in excel template. Each day create new file with the day and enters the data and calculate the efficiency using same template.
The excel file has six sheets call DAY-Line 1, DAY-Line 2, DAY-Line 3 and there are over 300 files with data on it. We need to calculate average efficiency in the past and bring it over to the template to update the efficiency automatically. Each sheet has the data of individual employees efficiency in same range ( B20 : B50). As I said earlier we have more than 300 files in same template with data in it. I tried to write formula using Average (indirect( " range and file name")) but works only when I open the workbooks.

Could anyone help me to write VBA code to achieve the task.
Thank you
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,650
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top