+ Reply to Thread
Results 1 to 2 of 2

Link two tables on two separate sheets

Hybrid View

doubled191 Link two tables on two... 04-04-2013, 12:24 PM
aydeegee Re: Link two tables on two... 04-07-2013, 08:15 AM
  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    washington
    MS-Off Ver
    Excel 2010
    Posts
    6

    Link two tables on two separate sheets

    Is there a way to link two separate tables to update each other. I have two sheets, each with a table. Table 1 contains a list of all projects and contains a lot of information. Table 2 is a tracking sheet of project page status for the same projects.

    I want the list of projects from table 1 to match and update table 2 when new projects are added (columns A and B) to table 1, i would like to avoid adding the new project in two places. I have tried a few formulas but the information doesn't sort correctly in table 2 when a fomula is used.

    I don't want to merge the tables because i don't want to cloud the information in table 1 with a tracking system.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Link two tables on two separate sheets

    Hi doubled191

    If you upload an example we can see exactly what is required, and make recommendations accordingly.

    Regards
    Alastair

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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