Macro for formatting existing sheet

[TZ Saic]

Dear all,

Every month I get workbook formatted on certain way (same way, maybe few rows more or less). However, I need to reformat it and add some additional calculations. Please find attached file with input sheet and output sheet.

I would like to aviod manual adjustments in input file, but recording a macro did not work well either.

Is there a code that would do the trick?

Thank you,

TanjaFormatting.xlsx

[Rioran]

Hello, Tanja!

How about fast solution? If you will press button in the attachment - you'll see deletion of unneeded rows. Works well, if your data every time have the same amount of columns and starts from 5-th row. Part with formulas behind "AK" column is not done yet, but if this button is appropriate for you - it will be easy to add.

Please Login or Register  to view this content.

[TZ Saic]

it works great