Hey all! I really need some help. Here's my situation. I have 24 different workbooks that have the same exact set up with different values. I need to find the average of each cell in the 24 different files and place the new value in an identical spreadsheet already set up.

The other problem is that there are separate sections so I would need some kind of loop to skip the blank cells and continue checking for values.

Can you PLEASE help.

Thanks,
Melissa

Hi Mellisa

You can achieve that using Functions. For example,

=AVERAGE('C:\ShasurData\[Book1.xlsx]Sheet1'!$A$2:$A$6,'C:\ShasurData\[Book1.xlsx]Sheet1'!A2:A6)

would find the average of all cells between A2 to A6 from both workbooks. It will also ignore Blank rows.

HTH

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thank you, but these files might be moved to a new folder, and when I tried that, after I enter the files a window prompts me to click on the file to update it. Am I going to have to open all the files every time I want it to update?

Thanks,
Melissa

Also, the average function only works for up to 18 and says it is too long to complete for 24 different files. Is there some other way to do this?

Hi

You can take the average twice of twelve excels each and then take an average of the two

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)