Hello Everyone

I am looking for a macro code with which I can sort data in a sequence which are eaxct or partially exact with each other in a single column of a sheet. To give you brief discription on my issue. We have a list of correct and partially correct entries. I am not able to perfrom sort because of the partial correct entries.

Could someone please help me with the code which help me to sort the data in a way in which the word from the cell is considered throughout the column and related word gets sorted in a column.

I hope that I covered the query in depth.

For ex
ADC company
Compant ABC
ABC

The data should apper in order.

Regards,
Jagdev