View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
masterbaker masterbaker is offline
external usenet poster
 
Posts: 19
Default Subtotal Macro Through Numerous Tabs

I'm looking for a macro that will subtotal data on each tab in a worksheet
that has many tabs - and which the number of tabs fluctuates. Basically:

(unsorted source data in sheet1, data sorted by account # on each tab
starting in sheet2)

Subtotal at change in column B; Sum columns A - K for sheet2, then again on
sheet3, and so on until there are no more tabs.

Thanks!