Hi there, I have 200 spreadsheets, all formated exactly the same but with different amounts of data in each (IE- sheet '1101' has 45 rows, sheet '1102' has 52 rows but they all have the same amount of columns). I need the macro to open each sheet and run the subtotal function: Subtotal Column F, Sum Columns L:Q, then move on to the next spreadsheet. I tried grouping all the sheets together but then I couldn't run the subtotal funcion... Any suggestions?

Hi, You should be able to group the sheets, then select a cell well below the last row to contain data on any of the sheets and enter the subtotal formula e.g., =SUBTOTAL(9,B2:B500)

If you entered this formula in cell B501, it would be present on all sheets in cell B501.

On a master sheet you could sum these or have linked cells showing all the subtotals e.g., ='1101'!$B$501

Regards

Good idea! I'll give it a shot... Thanks!

Ask Your Question

Weekly Poll