subtotaling columns that change daily?

[sscfa]

How can I create a macro that after sorting and filtering data, allows me to subtotal a column that changes day to day?

 

[SkipVought]

Hi,

You don't need a macro to do this.

faq68-1331

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[firefytr]

Also think about a Pivot Table. You can keep a defined name, as Skip shows with his link, to keep this range dynamic. The only caveat of Pivot Tables and keeping a dynamic named range is you must use the Offset/CountA method and cannot use the Rept/BigNum method.

Dynamic Pivot Table source:

http://www.contextures.com/xlPivot01.html

Finding last value with formula (thus able to make dynamic named range):

http://www.xldynamic.com/source/xld.LastValue.html

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci