Hi

Below is my requirement

I have 100 rows in a excel . I need to sort this rows based on column A .But this sorting is not ascending or in descending order .I need the sorting to be done by the order I mention

Eg:


Rows present in Excel



AAA 123
FFF 111
GGG 456
DDD 654
AAA 775
FFF 986
TTT 777


I need the Column A to be sorted in this order


DDD
TTT
AAA
FFF
GGG


Hence my output must be like this



DDD 654
TTT 777
AAA 123
AAA 775
FFF 986
FFF 986
GGG 456

Please let me know whether this can be achieved with excel macro or formulas.