VBA Macro which create new lines by codes

[DocAElstein]

.... I decided to use if-clause and apparently it works, ......

..? ...Can you elaborate on what you mean by that, please

---

( Do you have any feedback for P45cal on his attempt for you )

[Alex Salt]

I mean 'If...Then...Else Statement' so that the macro would add '0' at the beginning of some codes if there was one initially (otherwise it erases '0'), you can see it in the attachment. Anyways, the problem is that the macro ignores '0' at the beginning of some codes (even if I add '0' in if-statement). I wonder if there is any solution, and i think there can be something done with arrOutTempCT().

[p45cal]

( Do you have any feedback for p45cal on his attempt for you )

We're getting .xls files but his profile shows Office 2016+ so the Power Queries should work.
In general, if someone I've tried to help completely ignores that help, I return the compliment when they later want further help.
That said, the attached includes a tweak to the query which tries to maintain the formatting.

[Alex Salt]

p45cal,

I'm sorry for ignoring, I completely forgot to answer you.
My point is that I need a VBA code (macro) that I could use for other worksheets. I see no macro in your solution. You solved the problem by using table-tools, which is not the thing I need.


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA