How can I replicate the Excel 2003 LIST function in an earlier version of
Excel, say 2000? I want to keep subtotals visible at the bottom of the
worksheet at all times and to dynamically update when filters change.
Although I am not concerned about inserting new rows...

Any help is much appreciated.

Regards,

JC