Re arranging LIST macro

[makinmomb]

column a to J original data

Column m to u manually re arranged data pushing words with below the list , used CRTL X and CTRL V which is manual

AAE
AEE
AEI
AEO
AEU
AIO
AIU
AOU
EEE
EEI
EEO
EEU

Find attached

[WideBoyDixon]

Are you looking to sort on column J? If so, this should do it:

Please Login or Register  to view this content.

WBD

[makinmomb]

It has not sorted the I want it

[beyond Excel]

Hello. Try with:

Please Login or Register  to view this content.

[makinmomb]

Gives me

Run time error 91
Object variable or With block variable not set

[makinmomb]

I need these to go down the rest upwards sorted by column H

AAE
AEE
AEI
AEO
AEU
AIO
AIU
AOU
EEE
EEI
EEO
EEU

[beyond Excel]

Gives me

Run time error 91
Object variable or With block variable not set

There are 6 expressions of the following type: [j1].
Replace with: Range("j1")

[WideBoyDixon]

It's not clear which column you want to sort on. This will sort on column F but if you want to sort on a different column, change the 5

Please Login or Register  to view this content.

WBD

[makinmomb]

It still not sorts me

I want it to sort in the order

AAE
AEE
AEI
AEO
AEU
AIO
AIU
AOU
EEE
EEI
EEO
EEU

Leave a row

then sort the balance which is

AEI
and so on

[makinmomb]

Re attached , i have created an index of sort , i need the sort in that order , those i have specified down should go on sheet 3