Macro to automatically Align Cells

[Karthik Sen]

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.