My suggestion (Data/Subtotals) doesn't require VBA. See the "About
subtotals and grand totals" topic in XL Help.

In article . com,
" wrote:

Could you be kind enough to give me an example
or point me to some link where i can get more info

i am new to vba