VBA FOR SUBTOTAL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alam - 20 Nov 2007 12:40 GMT

THIS MY DATA
EMP. NO.    NAME     NOS
3120    MICHAEL     530
3120    MICHAEL     550
4987    PAUL    700
4987    PAUL    685
5033    ANTHONY     300
5033    ANTHONY    90

I WANT ABOVE DATA IN SHEET2 TO BE LIKE

EMP. NO.    NAME     NOS
3120 Total    MICHAEL     1080
4987 Total    PAUL    1385
5033 Total    ANTHONY     390
Grand Total        2855
THERE IS ANY VBA CODE TO MAKE IT AUTOMATICALLY.
PLEASE HELP
THANKS

Reply to this Message

Mike H - 20 Nov 2007 12:54 GMT

Hi,

You don't need VBA. Select your range including headings and then

data|subtotals
Ensure sum and the column to sum are selected and click OK.
If you want to apply this using VB then record yourself doing it.

Mike

> THIS MY DATA
> EMP. NO.    NAME     NOS
[quoted text clipped - 15 lines]
> PLEASE HELP
> THANKS

Reply to this Message