Sort Worksheet in a Workbook based on another Workbook

[BenK]

Hello Guys,

I would highly appreciate your help for this problem.

Does anybody have a code to sort the worksheets in a new workbook based on the original workbook? Below is the code I am using to duplicate Worksheets from the original workbook. However, new tabs are sorted alphabetically. I was trying different things but nothing worked so far.

Any idea? Is it possible to add something to the code in order to sort the tabs or do I need to create a new macro?

Thank you in advance for you help!

Regards

Ben

Please Login or Register  to view this content.

[bongaan]

Mr Ben again...not happy with my solution he wants it sorted as well!!

Dim the following variables:

Please Login or Register  to view this content.

insert the following code inbetween the last and second last line of your above sample code (between Next and End If)

Please Login or Register  to view this content.

It's probably not the most elegant programming but it should get the job done