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/vb...acro_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).
Stupac09 wrote:
the problem is im not even sure where to begin
"Dave Peterson" wrote:
Record a macro when you do it manually. You'll have code that may work--or need
just a bit of tweaking.
Stupac09 wrote:
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
--
Dave Peterson