Macros

[FL]

--
FL

 

[Stupac09]

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?

 

[Dave Peterson]

Record a macro when you do it manually. You'll have code that may work--or need
just a bit of tweaking.

 

[Stupac09]

the problem is im not even sure where to begin

Record a macro when you do it manually. You'll have code that may work--or need
just a bit of tweaking.

 

[Stupac09]

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.

 

[Dave Peterson]

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).