Hi guys i need help in designing a macro that would go in a folder containing over 300 excel file and do an average and stdev of Column I , L , M , N, P... and each column contains around 58-62 rows of data. how would i do that?manual solution is outta question ..