Hi All,

Could you make this process using VBA..

Process

Sheet "TB"
I will Copy the TB balances from external programme.
I will start assigning Grp_1 to Grp_7 Mannualy.
Copy the the data which matches same criteria Grp_1 to Grp_7(mandatory to match) to sheet "NT"

Example: 1

"NT BS Equity and liabilities Shareholders' funds Share capital 0 2 Mr S Share Capital 0 210
NT BS Equity and liabilities Shareholders' funds Share capital 0 2 Mr Z Share Capital 0 211"

In the above example Grp_1 to Grp_7 matches same criteria, so VBA will copy the data and paste in sheet "NT" and do SUM of these two entries (there may be chances it runs to several lines)


Example: 2
"NT BS Equity and liabilities Shareholders' funds Reserves and surplus 3 Securities premium reserve 220

IF Grp_1 to Grp_7 has only one line item, so VBA will copy the data and pasted in sheet "NT" and do SUM of the one entry.


Sheet "NT"
FROM Sheet "NT" to sheet "BS"
The total of "NT BS Equity and liabilities Shareholders' funds Share capital 0 2 Total 0 421" will copy and paste in sheet "BS"


FROM Sheet "NT" to sheet "PL"
The total of"NT PL Revenue Product revenue 0 0 13 Total 0 370" will copy and paste in sheet "PL"

Sheet "PL" & "BS"
SUM the total Revenue
SUM the total Expenses

SUM the total Total Equity and Liabilities
SUM the total Total Assets
Extract to respective sheets.xlsx
Thanks in advance