Copy row grouping from one worksheet to another

  • Thread starter edwards.richard
  • Start date
E

edwards.richard

Every month I get a new P&L template that can add or take away
accounts (rows) which are grouped
(data->group) and formatted. What I'm trying to do is copy the
formatting and grouping to a new worksheet without copying the whole
worksheet If I copy the whole worksheet, the grouping comes over but
destroys my formulas. Is there a way to programmatically copy the row
grouping from one workheet to another?
 
R

ryguy7272

Perhaps something liek this:

Sub Macro()
Cells.Select
Selection.Copy
Windows("Book1").Activate
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub

Always make a backup of your data before trying anything new!!


Regards,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top