Copy a Worksheet based on Outline

[atm]

Hello!

There is a budget worksheet that has several outlines:

Level 3: Has values/numbers for the details
Level 2: Has formulas/(sub)totals for level 3 items
Level 1: Has formulas/Totals for Level 2 items

My boss wants me to create a macro that will "copy" the worksheet but:
1. Will not copy Level 3 items
2. Will copy level 2 items but not as formulas but as values
3. Will preserve the formulas for level 1 items.

I d not have much experience programming in Excel VBA. And I would like to ask the community on how I could do this.

Thanks so much in advance.

 

[patel45]

Attach please a link to a sample file

 

[atm]

Please see the link for an example sheet. Thanks so much in advance!

http://gracetrivino.com/tmp/examplesheet.xlsx