+ Reply to Thread
Results 1 to 2 of 2

Managing Tabs in large Workbooks

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    USA
    MS-Off Ver
    Excell for MAC 2011
    Posts
    1

    Managing Tabs in large Workbooks

    I have forecast spreadsheet that I am using for a new business, for each new market I have three worksheets that all the calculations happen on then I have a consolidated worksheet and summary or report work sheet. We are now on our sixth new territory so I have a total of 21 worksheets with new territories being added. I have considered having a new workbook for each market with links to a summary workbook, but my experience of trying maintaining multiple linked workbooks has not been good. Is there any way to group sheet tabs in a sheet tab folder or as I suspect there is not any suggestions on how to help me mange 30/40 worksheets. All I really want to do is navigate quickly to a specific tab without scrolling through 100 options!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Managing Tabs in large Workbooks

    As your workbook grows, best to consider adding a central navigation sheet, and within each sheet some navigation controls as well.

    Create a front sheet that has cells with HYPERLINKS (CTRL-K to add a hyperlink to a cell) to other sheets. Put each group of 3 sheets in an organized manner on a single row, the next 3 sheets in the next row, etc.


    DataGroup1 Report1 Summary1
    DataGroup2 Report2 Summary2
    DataGroup3 Report3 Summary3
    DataGroup4 Report4 Summary4
    DataGroup5 Report5 Summary5



    Now, at the top of each of your data sheets is another set of hyperlinks.

    On the DataGroup1 sheet would be 3 links:

    HOME Report1 Summary1

    On the Report1 sheet would be:

    HOME DataGroup1 Summary1

    You get the idea.

    Now with your front Navigation sheet with hyperlinks to every sheet, and your data sheets with links to each other or back home to this navigation sheet, you can get from one sheet to any other with at most two quick clicks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon 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!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count/Sum Formula for large audit (150 tabs)
    By markk2011 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-26-2013, 01:51 PM
  2. Need Macro for managing information between two excel workbooks
    By mikhil16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 05:11 PM
  3. managing 2 workbooks at once
    By o811marine in forum Excel General
    Replies: 3
    Last Post: 07-23-2012, 10:25 AM
  4. Replies: 5
    Last Post: 11-14-2011, 04:48 PM
  5. Pulling large amounts of data from varying tabs
    By bjvick in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2010, 05:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1