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.
Bookmarks