+ Reply to Thread
Results 1 to 5 of 5

Linking 10 excel sheets to 1 master sheet

  1. #1
    Registered User
    Join Date
    01-10-2020
    Location
    ireland
    MS-Off Ver
    1911 2019
    Posts
    3

    Linking 10 excel sheets to 1 master sheet

    Hello all

    I could use some assistance, I have 10 individual progress tracker excel sheets that show % completion on each project.

    my question is, is there a way to have all 10 individual sheets linked to 1 master progress tracker? so when I update an individual excel tracker, the tab in the master copy with this data will auto update? just to make life easier and get an overall %.

    maybe there is a better way than what I have said, if so then please speak up.

    thanks for the assist.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Linking 10 excel sheets to 1 master sheet

    When you say "sheet" do you mean workbook? It's a little unlcear what you've actually done. Some sample workbooks would be much better

  3. #3
    Registered User
    Join Date
    01-10-2020
    Location
    ireland
    MS-Off Ver
    1911 2019
    Posts
    3

    Re: Linking 10 excel sheets to 1 master sheet

    Kyle123

    yes workbook I mean

    if you can show me how to attach workbooks il happily do it, im new to forums and my excel skills need sharpening.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Linking 10 excel sheets to 1 master sheet

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    01-10-2020
    Location
    ireland
    MS-Off Ver
    1911 2019
    Posts
    3

    Re: Linking 10 excel sheets to 1 master sheet

    Kyle

    I have drawn up and attached a quick example of what im trying to achieve, hope you can see it ok.

    basically, Projects 1, 2 & 3 are representations of individual excel workbooks that I wish to add into one master tracker ( I need this data to be linked to each individual tracker - so when I edit project 1 tracker individually it auto updates into the master tracker)

    the purpose of this is to keep track of each individual project but also get a grand total % of their progress for client valuations

    if you have a simpler method that this please do tell me im open to idea
    Attached Files Attached Files

+ 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. Linking multiple sheets to one master sheet
    By bryandecker in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2017, 03:17 PM
  2. replicating a column from master sheet to other sheets and sorting on the master sheet
    By kstormy1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2016, 07:57 PM
  3. Problems linking numerous sheets in workbook to one master sheet
    By Joanne2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2013, 05:50 AM
  4. Linking Cells from Master sheet to data sheets in workbook
    By Ag Research in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2013, 04:42 AM
  5. Replies: 4
    Last Post: 03-29-2012, 03:12 PM
  6. Linking several sheets to one master sheet
    By Spager007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2008, 03:03 AM
  7. Linking columns from master to sheets
    By Tom Sawyer in forum Excel General
    Replies: 0
    Last Post: 04-03-2008, 04:07 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