I have a workbook which contains approx 50 worksheets. Each row in each worksheet is an identically formatted record (with headings). Some worksheets have 100 records and some much fewer. I need to to create subtotals for the records on each worksheet using the same criteria. i.e. Sub totals for the same value fields when a product line changes in a specific field.
So far I have had to reset the criteria each time. Is there a quicker way? (short of using an MSAccess developed system.)
Any help gratefully appreciated.
David