Basic guideline required - Formatting

i need to fuse roughly 200 income statements and get them into a presentable format.
mostly been using AHK so far and legit started using VBA today due to necessity.
if you have any helpful resources to speed up my VBA entry, by all means, throw it my way.

not expecting people to shove me solutions up my rear but sometimes you literally only need to copy paste to make someone elses endeavours so much easier.

i added an example of the situation i need to solve with the few fixes i already have.

1. moving A-B below C-D
2. deleting rows containing cells with "text" in column 'i'
3. adding pagebreaks below "text"
4. adding new empty rows below "text"
5. adding "text" in cell above A
6. formatting rows starting with "text" to bold

A
x
x
x
B
C
x
x
D
A2
x
x
B2
C2
x
x
D2


2.

Please Login or Register  to view this content.

3.

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)