View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] edwards.richard@gmail.com is offline
external usenet poster
 
Posts: 1
Default Copy row grouping from one worksheet to another

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?