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.
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.