| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA FOR SUBTOTAL
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Sort, Subtotal, Label Subtotal, Insert row | Excel Programming | |||
Threaded Mode
