+ Reply to Thread
Results 1 to 5 of 5

Linking data to different tabs in excel

  1. #1
    Registered User
    Join Date
    02-27-2010
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    14

    Linking data to different tabs in excel

    Hi,

    I am not as great as my employers think I am in excel and have been asked to carry out the following task. They will have a master tab that has a table that looks something like this:

    Task Assigned to Completion date

    Task 1 Employee 1 June 2010
    Task 2 Employee 2
    Task 3 Employee 1 August 2010

    Want they want is a separate tab for each different employee with their individual assignments that will automatically update when the master tab has been amended. Is this possible in Excel or would Access need to used.

    Thanks in advance for the help.

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Linking data to different tabs in excel

    G'day and welcome to the forum,

    Here is a similar challenge that has been solved and can be applied to your situation. Download the example sheet supplied by Martin.

    http://www.excelforum.com/excel-gene...job-sheet.html

    If your having problems, upload an example of the layout and dummy info then we can assist you.

    Cheers
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Linking data to different tabs in excel

    funny that i forgot about it !!! here's another one i just did!
    (i hid zero values with home button/excel options/advanced unchecked show zero in cell)
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    02-27-2010
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    14

    Re: Linking data to different tabs in excel

    Thanks a lot for all the help.

    I'll give it a go on Monday.

    Also martindwilson, do you have any idea how I can hide zero value in earlier versions of excel?
    Last edited by johnlol; 02-27-2010 at 10:55 AM.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Linking data to different tabs in excel

    same way but tools/options/view tab ah for some strange reason i thought you had 2007 there is a function in there that wont work with earlier excel so try this version instead.
    Attached Files Attached Files
    Last edited by martindwilson; 02-27-2010 at 11:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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