Rearrange the worksheets in two workbooks

Dear Friends

I need to re-arrange the worksheets in a workbook.

I have two workbooks, having same number of worksheets with same names, but they are placed in randomly.

So I will take first Workbook as a reference and I need to change the places of worksheets in the second workbook as per the places of worksheets in the first workbook.

Please drop few lines/ a code for this problem.

Thank you in advance.

Rgds

Vishalkumar

Hello VishalkumarT,

Here is a macro to arrange the second workbook's worksheets the same as the first's. The macro should be placed in the first workbook. Copy the code, and after inserting a Standard VBA Module into your workbook, paste the code into it. Change the name of the second workbook in the code, currently "Book2.xls", to the name you will be using.

Please Login or Register  to view this content.

Sincerely,
Leith Ross