Hi Guys,
I currently have an excel workbook with 50-100 sheets/tabs in it, currently organized from oldest to newest. It would save me countless seconds of scroll time if I could inverse the order of the sheets/tabs.
Is there any way to do this built into excel?
Thanks,
Rafi
No, but here's a macro you can use:
Please Login or Register to view this content.
How/Where to install the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ok I have a solution for you.
This is my macro suite for big workbooks.
Auto open will create a userform to help you navigate.
Contents will create an index sheet
Sort the index in whatever manner you want
Then run sort to rearrange the workbook to match your index
JBeaucaire, that worked so beautifully I could cry. Thanks!
Last edited by RafiE; 09-08-2014 at 07:25 PM.
As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.
thank you, worked great!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks