subtotal/grouping problem
 

I have a macro that cuts rows and pastes them into another excel workbook
that has a subtotal format. When the rows are inserted to the proper
location it messes up the grouping so all the groups are incorrect it's
recognizing the subtotals but it's just not grouping it. Is anyone aware of
way to fix this? I'm trying to make it so that it will just keep adding the
info. into the proper location and so that it will keep extending the group.

Thanks
MartÃ*n Hinojosa

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1

subtotal/grouping problem
 

I assume you used Data - Subtotal to insert your subtotals. The only
effective way to include now data would be to remove the subtotals and add
teh new records and then replace the subtotals. An easier solution might be
to change your subtotals to a pivot table that is refering to a dynamic
range... That will work quite a bit easier. Let me know if you want help with
that...
--
HTH...

Jim Thomlinson


"Hinojosa via OfficeKB.com" wrote:

I have a macro that cuts rows and pastes them into another excel workbook
that has a subtotal format. When the rows are inserted to the proper
location it messes up the grouping so all the groups are incorrect it's
recognizing the subtotals but it's just not grouping it. Is anyone aware of
way to fix this? I'm trying to make it so that it will just keep adding the
info. into the proper location and so that it will keep extending the group.

Thanks
MartÃ*n Hinojosa

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1