Hello all,
--I have a macro that opens many excel spreadsheets and saves the first worksheet as a new tab in a "master" spreadsheet. The "master" spreadsheet then names each tab based on the question # found in each worksheet.
So, my "master" worksheet has tabs named something like:
q1 q2a q3 q5
What I need to do is create a list box which lists out all of the tab names, allows me to choose the order that the tabs will appear, and then rearrange the tabs to reflect that order
So, for the above, I need a list box which would display:
q1
q2a
q3
q5
and would allow me to specify that the order I want to be:
q5
q2a
q1
q3
(or whatever order I want)
and then rearrange the tabs so they appear as:
q5 q2a q1 q3
The number of tabs and the names of the tabs will vary.
Thanks for the help!
Bookmarks