Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!uwm.edu!uwvax!astroatc!nicmad!agrigene!overby From: overby@agrigene.UUCP (Scott Overby) Newsgroups: comp.sys.mac Subject: Automatically generating subtotals in excel Keywords: excel macros Message-ID: <483@agrigene.UUCP> Date: 14 Dec 89 18:43:46 GMT Distribution: usa Lines: 15 I need to automate the process of generating a sub total in a list of sorted items in an Excel 2.2 document. I assume one would use macro(s), but what would the general approach be? The number of items within a subgroup may vary from application to application so the routine should be robust to habdle the different situations. I don't need the exact syntax, but an general wording of the steps involved is sufficient. Thanks in advance. Scott Overby Agrigenetics Co. Madison WI