Re-positioning two columns bases on each other.

[kumarrajesh]

Hi All,

Am Rajesh, need help in writing a macro.

I would like to reposition by adding a blank cell after comparing both the columns. Please check the image attached.

Thank you very much in advance.

 

[vletm]

kumarrajesh
Is there any logic of from 'College Id' to 'Country'?
I skip that case.
Would it be something like this?

 

[vletm]

Aren't these same? Snapshot looks same!
https://chandoo.org/forum/threads/reposition-cells-in-a-column-based-on-another.37594/

 

[kumarrajesh]

Hi Vletm,

Your solution worked perfectly. Thank you very much.
Actually, there is no logic between the columns to include.
If you are ok and have time, could you please elaborate on the logic you used in the program.

Regards,
Rajesh.

 

[kumarrajesh]

Hi Vletm,

While attaching snapshots, I have a bit problem so got attached 2 times.
Sorry, if that created confusion.

 

[vletm]

kumarrajesh
What/where attaching?
What kind of problems? ... with Excel?
Three minutes ago everything was perfect.
Is there any logic of from 'College Id' to 'Country'?

 

[kumarrajesh]

Hi Vletm,

Your solution worked perfectly fine, my second reply was for your second message regarding snapshots.

 

[vletm]

kumarrajesh ... hmm?
That my message was about same kind of question with 'Excel'.
Someone else has same kind of challenge and You also wrote there.

You asked about my #2 reply... logic is:
1) Find out all possible items
2) Sort those
3) Move original items to needed positions
as You would see...