How to Arrange Worksheets in Custom Order

[steventing]

Hi all,I have a Excel file with almost 100 worksheets named randomly. ie. ABC123 ABC246 CDE246 CDE135...


How to arrange these worksheets in a defined order ie. 1st Worksheet CDE135
2nd Worksheet ABC123
3rd Worksheet CDE246
4th Worksheet ABC246....

Thanks in advance for your help.

[venkat1926]

see attched file steven.xlsm
the FIRST SHEET (sheet1) in which the ranks of the four other worksheets are given as you want.

the other sheets are in some orderl

now run this macro and see whether you get what you want?

Please Login or Register  to view this content.

[venkat1926]

apologise. forgot to attach the file

[jindon]

Please Login or Register  to view this content.

[steventing]

apologise. forgot to attach the file

Dear venkat1926, thanks for your help! your code is exactly what I want, however, when I change the worksheets a bit, the macro doesn't work again.

Please see attached file for your reference.

stevenmod.xlsm

Anyway, really thanks for your help

[steventing]

Please Login or Register  to view this content.

Dear jindon, thanks for your code, but I prefer to list the order in a Worksheet instead of key in the array in the code because I have almost 100 worksheets in my file.

[jindon]

Please Login or Register  to view this content.

[steventing]

Please Login or Register  to view this content.

Dear jindon, thanks! This work like a charm, you save my days! thanks a lot for your help