The code does exactly what you asked for in your original post, and it does create output that matches the first example file you uploaded (before you changed it).

"Mainly the code you posted didn't allow me to insert an entire row" --Your original post specifically said that Column B should not change, and the original example file did not have inserted rows, just inserted cells in Col A. Also, the current file you uploaded doesn't show that entire rows have been inserted.


"and when I switch the columns the code didn't work" --Of course it didn't. That is because what you asked for and what you wanted were entirely different.

"I need more than that, attached is an example contains "Before" and "After" sheets that exactly describe the other problem I faced when applying your solution" --I don't know if you are saying that this file shows the issue after the code is run or after.

And in this last sample file... On the After sheet, WHY aren't there inserted ranges in rows 28 thru 32? I have written another macro, but it doesn't stop at row 27, so I hesitate to post the code until I know what you expect it to do.