VBA to Create Grouping (Difficult)

[Excel Fox]

Biz, can you please take us through the flow here. Not able to follow how you reach from Before to After

[Biz]

Hi,

I have tried to group all expenses based Parent - Child relationship. If I click on Level 2 on After Worksheet tab it tells me all children belonging to a Parent.
1000 Group Accounts
41 Profit and Loss
39 Net Surplus / (Deficit) After Tax
42 Net Operating Surplus / (Deficit)
45 Net Operating Expenditure
88 Operating Expenditure
142 Operating Revenue

43 Net Non-Operating Surplus / (Deficit)
47 Non-Operating Expenditure
48 Non-Operating Income
40 Income Tax Expenditure
44 Income tax expense

6 Liabilities & Equity
28 Liabilities
30 Non-Current Liabilities
31 Current Liabilities

29 Ratepayers equity
32 General equity
33 Restricted equity
34 Designated funds and reserves
35 Targeted rate reserves
36 Other reserves
37 Revaluation reserve
38 Minority interest
7 Asset
8 Assets
9 Non-Current Assets
11 Property Plant and Equipment
12 Investment Property
13 Right To Acquire Assets
14 Intangible Assets
15 Goodwill
16 Livestock
17 Investments In Subsidiaries
18 Investment In Associates
19 Other Financial Assets
20 Derivative Financial Assets

10 Current Assets
21 Trade and Other Receivables
22 Inventories
23 Other Financial Assets
24 Derivative Financial Assets
25 Non-Current Assets Held For Sale
26 Income Tax
27 Cash and Cash Equivalents
169 Investment

For instance, Operating Expenditure includes Expenditure On Activities which includes following:
Staff
Professional Services
Contractors
Office Consumables
Occupancy and Utilities
Repairs and Maintenance
Insurance
Depreciation and Amortisation
Management Fees
Inter-Entity Funding
Grants and Sponsorship
Cost Of Goods Sold
Other Expenditure On Activities
Internal Charges and Allocations
Settlements


If I click on level 1 in After Worksheet tab it gives consolidated accounts structure.

Biz