VBA FOR SUBTOTAL

[Guest]

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

 

[Guest]

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