I would like to use VBA to Subtotal Multiple Excel Sheets. For Each change in the Project Name column I want to use the sum function and add the subtotal to the Balance Amount. Not all sheets in the Workbook will be subtotaled.
Conditional Sum and multiple conditions across different sheets I've looked in a variety of books and a variety of places - but I haven't quite figured out if it's possible to do what I want. Nov 21, 2012 · it works great for 1 sheet but the data is spread across multiple sheets because of the row limit in excel being “only” about 1 million. how can i use this approach with an index match instead of vlookup, i already have a list of my sheets in a named range named sheets. thanks in advance for your help