Hello there,
I'm relatively familiar with Excel macros, but I can't find what I'm looking for anywhere. I have a fairly expansive spreadsheet that has 3 or 4 dozen sheets with varying names and it gets exceedingly difficult to find the right sheet when I either scroll through all of them or RClick the scrolling arrows and search for the right sheet. I found other's alphabetizing VBA macros, that works but I need to isolate 6 or 7 of the sheets to be at the front of the sheets that are alphabetized. Can someone help me understand how to get the result I'm looking for?
I.E. *all values are arbitrary*
X1-X50 = sheets, their order is random
X4, X8, X24, X37, X15, X9, and X17 must remain in this respective order while remaining sheets are alphabetized either in ascending or descending order.
The macro that I currently have is:
****************************
****************************
I tried editing it to fit my needs below:
****************************
****************************
Thank you
Bookmarks