Function to link workbooks problem

[andyp161]

Is it possible to create links from workbooks so that I can create
central workbook that will contain all of the worsheets from severa
different workbooks e.g. if workbook 1 contains worksheet A an
workbook 2 contains worksheet B, I want to create a central workboo
that will be linked to workbook 1 worksheet A and workbook 2 workshee
B so that it will contain up to date copies of worksheet A in workboo
1 and worksheet B in workbook 2.

Kind regards

And

 

[Arvi Laanemets]

Hi

Let you have both users workbooks (User1.xls, User2.xls, data in both
workbooks are on sheet Data, in columns A:C) on some shared network
resource. Map this network resource, p.e. as X.

In your would-be master workbook, create sheets User1 and User2.
On sheet User1, into cell A1 enter the formula:
=IF('X:\[User1.xls]Data'!A1="","",'X:\[User1.xls]Data'!A1)
and copy it to range A1:C?, for at least for same number of rows as you'll
have in table in User1.xls. Format columns, when needed (you can't use Text
format of-course), and set column widths and borders etc.
The same for sheet User2 (adjust formula, of-course).