Record a macro when you apply the subtotals.

Use the outlining symbols at the left to hide what you want hidden.

Select your range
edit|goto|special|visible cells only

Copy and paste.

That recorded macro should be pretty close to what you need.

LJB wrote:

Need to copy subtotals to a new worksheet as one of many steps included in a
macro. The row number for the subtotals will change each month. Any ideas
how to include this copy & paste in a macro without grabbing the wrong row on
the 2nd and subsequent months? Thanks!
--
LJB

--

Dave Peterson