I have kept a spreadsheet for years that contains tons of lists that I may need on a moment's notice. The problem is I have to slowly pick my way through all the tabs at the bottom to find the one I'm looking for.
Is there a way to group several workbooks together under one tab?
e.g. rather than having tabs at the bottom like this:
Paul Mary Jim Nancy 10-12-13 Mike Sally Equipment Sizes Scores Travel 10-14-13 9-05-13
I'd rather see:
Men Women Dates Stats Equipment
Under the "Men" tab I would see the following tabs: Paul Jim Mike
Under the "Women" tab I would see the following tabs: Mary Nancy Sally
etc.
Or, is the only way to sort the spreadsheet quickly -a table of contents with hyperlinks? (not preferred)
Is there a way to group several workbooks together under one tab?
e.g. rather than having tabs at the bottom like this:
Paul Mary Jim Nancy 10-12-13 Mike Sally Equipment Sizes Scores Travel 10-14-13 9-05-13
I'd rather see:
Men Women Dates Stats Equipment
Under the "Men" tab I would see the following tabs: Paul Jim Mike
Under the "Women" tab I would see the following tabs: Mary Nancy Sally
etc.
Or, is the only way to sort the spreadsheet quickly -a table of contents with hyperlinks? (not preferred)