Macro to automatically Align Cells

Hi All,

I have a excel sheet with two columns of data. Data in both the columns are the same however it is sorted in different order.
I need the contents in the second column to get the sorted automatically based on the order given in the first column. I have attached the excel sheet for your reference.

Can anyone pls help me on the above macro ?

Hi

Forum rules says you should mark your thread ”solved” after getting help. As this is your 15th posting I’m a bit curious about your previous postings.

I see that none of the earlier thread is marked as “solved” even if forum members that have helped you and suggested solutions to your problems.

Giving feedback by saying thanks (as you do) is always appreciated and adding a comment like “this solved my problem” or “this didn’t solve my problem because ..” is helpful as well but a thread should be marked “solved” if and when a solution is given!

Speaking for myself I’m reluctant to help people who don’t stick to forum rules.

Alf