+ Reply to Thread
Results 1 to 4 of 4

Master Sheet With Links to Other Sheets

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Master Sheet With Links to Other Sheets

    Hello,

    I work for a production hombuilder and I am developing a schedule to track community development. We have over 20 communities that we will need to use the sheet that I have devised to track progress. Is there a way that I can somehow create a link to an individual sheet within the workbook for easy navigation?

    The alternative I believe would be to just have all of the communities on one sheet but have to scroll down a number of rows to display the timelines.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Master Sheet With Links to Other Sheets

    yes, you can keep each community in a tab and summarize it in a master tab

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Re: Master Sheet With Links to Other Sheets

    How? I'd like to be able to jump directly to that sheet either with an input box or some sort of drop down menu that the user can use to view detail within the individual community.

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Master Sheet With Links to Other Sheets

    send a sample workbook and we will show you how...

+ 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. Master sheet to split sheets back to another master sheet
    By FurRelKT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2017, 02:08 PM
  2. Macro to apply a filter from one sheet (a master sheet) to all sheets in workbook
    By SeaniGeld in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2013, 02:00 PM
  3. [SOLVED] Consolidating multiple worksheets into one and retain links to source data in master sheet
    By enigmadreama in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2012, 08:33 PM
  4. Help. Master Sheet to Sub Cat. Sheets
    By spitfire627 in forum Excel General
    Replies: 0
    Last Post: 02-20-2009, 11:49 AM
  5. one master sheet and four update sheets?
    By jodenice in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2008, 07:07 PM

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