VBA: Loop Analysis of Multiple Excel Workbooks

[letonuslepus]

Hi, I'm trying to analyze many workbooks (formatted exactly the same) and place the analyzed data into a new master spreadsheet. How would I write a VBA macro to take an avg and stdev of a range of data for each workbook in a folder...they are labeled in the fashion "Myworkbook__00#" # being 1-20 and then deposit each avg and stdev into a new master sheet into respective ordered rows? I am struggling how to analyze the data in a loop as I am familiar with matlab not VBA macros. Attached is an example of the data I have. I am only needing to analyze the 3rd column of data

Thank you

 

[offthelip]

try something like this:

Sub test()
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row
ave = WorksheetFunction.Average(Range("C2:C" & Lastrow))
std = WorksheetFunction.StDev(Range("C2:C" & Lastrow))
MsgBox "Average= " & ave & " Stdev= " & std

End Sub

I just realised this is only part of your question