finding average between values from different workbooks

[marionette]

Hello to everyone!

I need your help! I have 100 workbooks named Value_1 to Value_100.. In a specific cell W2 in sheet (named Model) in all workbooks there is some value (that comes as a formula result).
I would like to write a vba code that finds the average of these 100 values and saves it in another workbook, sheet2, cell O2..
Can anyone help me please? I tried many things, but i'm an absolute beginner and nothing works...

Thanks in advance!

[mrice]

Try this macro

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

[marionette]

mrice,

thanks a lot!! you made everything easy for a beginner like me..
Thanks for the detailed explanation! My problem is solved now!