There are two workbooks in two networked computers.
Workbook b.xls contains sheets("b1"), Sheets("b2")
Workbook c.xls contains sheets("c1"), Sheets("c2")
In another computer i want to create a new workbook a.xls. In a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").
b.xls and c.xls updates frequently. How can i create a.xls and make a.xls automatically changes with the changes of b.xls and c.xls.
Workbook b.xls contains sheets("b1"), Sheets("b2")
Workbook c.xls contains sheets("c1"), Sheets("c2")
In another computer i want to create a new workbook a.xls. In a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").
b.xls and c.xls updates frequently. How can i create a.xls and make a.xls automatically changes with the changes of b.xls and c.xls.