Hello Everyone

I am facing an issue while creating a Macro in VBA. We have a sheet which consist entries in 1000's. The entries in a column is combination of correect and partially correct entries.

Ex -

ABC company LTD
Company ABC LTD

I can't use Excel function to sort such entries.

Is there a way to create Macro which will filter such result in a column and sort the related data one after the other. Like the way it is appearing in the example above.

Is it possible to create a macro and put condition in this column, like in the above example if it find the word "ABC" in the column, move both the correct and partially correct entry with its adjustant data to other/adjucent sheet and that to in sequencial order.

Regards,
Jagdev