basic spreadsheet

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I want to sort and subtotal data using a macro. I'm sure
you've covered this topic before, but I can't seem to
find it....what are the macro commands? I want a
subtotal every time the driver name changes.

COL A COL B
Driver Pay

Thank you.
 
Pam,

Look for the "Subtotal" method and the "Sort" method in the Excel VBA help.

Regards,
Jim Cone
San Francisco, CA
 
I'd record a macro when I did it once to get the basic syntax correct.

Data|Subtotal is where you'd find it on the menubar.
 
Back
Top