Macros

  • Thread starter Thread starter FL
  • Start date Start date
I cant seem to create a new thread so hopefuly This will work. I need
tocreate subtoals using macros and can not seem to figure out how to do it.
I understand how to use the shortcut keys but don't know what the next step
is. Any help?
 
Record a macro when you do it manually. You'll have code that may work--or need
just a bit of tweaking.
 
the problem is im not even sure where to begin

Dave Peterson said:
Record a macro when you do it manually. You'll have code that may work--or need
just a bit of tweaking.
Click to expand...
 
I know how to make macros but once I assign a shortcut and click ok what do I
do to make it so I get subtotals.
 
In xl2003, I'd start by:
Tools|Macro|Record new macro
Give it a nice name and store it in this workbook.

Then
Select the range
And data|sort (if you need to sort)
then Data|subtotals

Then stop recording.

Since you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

and
Tushar's Mehta site:
http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/

==========
I think that it'll be easier for you to record the macro when you do it
manually. You could be subtotalling 1 column or 17 or skipping fields. Your
recorded macro would get close than most guesses (at least closer to my
guesses).
 
Back
Top