I have a folder of about 20 Workbooks. I have a series of formulas that need to be applied onto all of these workbooks. Each workbook in the folder has values from A2:E722, with a header on the first row. The formulas refer to the values in this range. I have a formula for mean in column F, median in Column G. and average in Column H. Is there a way to apply this formula for all the workbooks across the board. Rather than copying and pasting the same formula to each workbook?