Making Statement of accounts

[Shabbo]

Dear Sir,

I wanted to make my data from row data to finalized data like as shown sheet 2 and three.

Once data is converted it should be saved in C:\Users\accounts\Desktop\Oustading Satement\ABC LTD.xlsx and another one like C:\Users\accounts\Desktop\Oustading Satement\AML LTD.xlsx.

Please advise how can it be done.

 

[vletm]

Shabbo
1) Clear data from needed layout sheet
2) Filter 'Raw data' as needed
3) Select result and copy it
4) Paste to needed layout sheet
5) Use 'Move or Copy ...' option from needed layout sheet tab
6) With'Create a copy' -> Move selected sheets: - (new book)
7) You'll have wanted result.
8) Repeat steps from 1 to 7 as many times as needed