--
FL

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.

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

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

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.

"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

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