Here is the file where I need it - it is without company data, so it looks a litte bit strange.
If anybody has more time, please, check, how could I replace all formulas in green. Normally, they are on each row.
(run macro separatelly, my composed macro will not work - as the Trial balance sheet is deleted.

Thanks a lot for any hint.
UpFile makrohrátky - funkční 01 - Copy.xlsm