Formula or VBA to align multiple cells with same value under one column

[RoanRSA]

Hi,I am a novice at excel and would appreciate any help I can get.

I would like to know is there a function/formula/VBA that one can use to align multiple cells with the same value across a worksheet into a specific column for for example:

I want to align all the cells highlighted in red with the value 3026 (Specific code) under column CH by inserting blank cells in front of 3026. It is very important that the 3026 values stay in its original row. Is there any other way of doing this without manually having to insert blank cells row by row so that all the 3026 values line up under column CH?

 

[raelharris]

Hi Joe4, in an effort to understand the VBA code you used here, would you be able to give a small tutorial explaining what steps to did to record or code this Macro? I have a real world task that involves the exact same issue as RoanRSA, but I would like understand what the Macro is doing at each step of the code.
Thanks in advance.

 

[Joe4]

Hi Joe4, in an effort to understand the VBA code you used here, would you be able to give a small tutorial explaining what steps to did to record or code this Macro? I have a real world task that involves the exact same issue as RoanRSA, but I would like understand what the Macro is doing at each step of the code.
Thanks in advance.

Welcome to the Board!

Loops cannot be recorded, so very little of the code I posted would the Macro Recorder help with. The original code that I posted has got comments in it, explaining what I did each step of the way. And in post 10, I explain some of the logic in more detail.

If you have other questions about specific parts of my code, please feel free to post them here.