copy separated range for each name from multiple sheets to another with calculation

[Maklil]

Hi
I want copying data from sheets Makili1,Maklil2 with the same formatting and borders with excluding the formulas , should be value
to sheet1 with calculation from column I : L POSTING (K) shuold brings from column BALANCE from first row under headers, DEBIT(L) should sum values in column (D) after first row under headers(second row (should be from row3),CREDIT(M) sum values in column (E) after first row under headers(second row(should be from row12)) for each name BALANCE(N)=POSTING+DEBIT-CREDIT somtimes add new sheets with the same structure and somtimes the customer doesn't contains value in POSTING (K) that's doesn't contains from the beginning then should sum normally . I want replacing data when run the macro every time becuase I will add and change data in sheets MAKLIL1,2 . the fourth sheet is what I expect result in sheet1 .
the data colud be 3500 rows fo sheets Maklil1,2 (this is a sample)
thanks

[nankw83]

Hi Maklil,

Try below code based on your sample file ...

Please Login or Register  to view this content.

[Maklil]

thanks , but there are two problems . the code copy to the bottom repeatedly when run the macro every time , should not do that just replace data ( can clear and copy in first sheet to avoid this problem).

[nankw83]

I have added one line to clear the data of sheet1 ... What is the 2nd issue ?

Please Login or Register  to view this content.

[Maklil]

What is the 2nd issue ?

what do you mean for this?

[nankw83]

thanks , but there are two problems

You mentioned that there are two problems, I have fixed the first one of deleting the old data before pasting the new data, what's the 2nd problem that you're encountering ?

[Maklil]

umm!! I think the same problem happened with calculation from column I : L and repeat the headers ,but your suggestion fixed all of thing
many thanks for you help