Linking Work Sheets

  • Thread starter Thread starter Troy
  • Start date Start date
The response should have worked.

If you are typing in a formula in WorkbookA that contains
a reference to cell A1 in WorkbookB, then you want to set
it up in the following way:

=[WorkbookB]Sheet1!$A$1

Not that the Name of the workbook you are referring to
should be in square [] brackets, followed by the Name of
the sheet in Workbook B that you are referring to (in this
case Sheet1), make sure this is enclosed in single
quotation marks (if there were any spaces in either the
name of WorkbookB or the name of the sheet you are
referring to in WorkbookB), then the cell will be an
absolute reference (enclosed with $ signs).

An easier way, however, is to have both workbooks open at
the same time, go to the cell you want to type the formula
in, press = then click the appropriate cell in the other
workbook that you want to refer to (note that in Excel
2000 this is easy as you automatically have a separate
window for each workbook - if you are using Excel 97 or
earlier (god forbid!), simply open Excel twice or go to
Window->Arrange->Tiled which will show all the workbooks
you have open on the screen).



-----Original Message-----
This Did not work
-----Original Message-----
Troy,

='[WorkbookA]Sheet1'!$A$1

Regards,
Kevin

How can I link Sheet 1 of Workbook A to Sheet 1 of
Workbook B?
Click to expand...


.
Click to expand...
.
Click to expand...
 
Back
Top