Try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"tlcnc" wrote in message
...
I have a worksheet that I want subtotals for loan amounts for each city.