+ Reply to Thread
Results 1 to 2 of 2

Excel linking and automatic data updation

  1. #1
    Registered User
    Join Date
    06-11-2009
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel linking and automatic data updation

    I need to automatically update a worksheet, when I change data in another worksheet in another workbook. There are many datas, so I thought formulas wont help.

    1.xls
    MCU--Feature--Load--TL1 Command--TL1
    Kosal--DB--Load 4--SSH Stack--Not Completed

    2.xls
    MCU--Feature--Load--TL1 Command--TL1
    Kosal--DB--Load 4--SSH Stack--Passed

    1.xls can contain other columns also. But "TL1 Command" and "MCU" value will be the same.

    When I make a change in 2.xls, the same change should reflect in 1.xls. For example, I have changed "TL1" as "Passed" in 2.xls. In 1.xls it should also change as Passed. I thought of keeping a button in 2.xls. If I press that button, then 1.xls should get updated.

    Any help is appreciated.

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Excel linking and automatic data updation

    It will be better to attach a sample file so that suggestion can be made ..... but you can use vlookup or index/match as well .....
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.

+ 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