Loop through mult spreadsheets and subtotal

Microsoft Excel 2003 (full product)
January 15, 2010 at 09:17:31
Specs: Windows 2003
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?

See More: Loop through mult spreadsheets and subtotal

Report •

January 15, 2010 at 11:55:34

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


Report •

January 15, 2010 at 11:59:20
Good idea! I'll give it a shot... Thanks!

Report •

Related Solutions

Ask Question