Linking a workbook to worksheets
 

Hello all
Was wondering if anyone has any experience linking worksheets to a workbook.
The problem I am having is that I want to link cell B25 from my (physician)
workbook to cell B27 of a (nurse's) worksheet 1(which is part of another
workbook). I wish to increment the cell to B26 being used in the physian
workbook to link to cell B27 in nurse's worksheet 2 and so on,following the
same pattern.Is this possible?
Thanks much in advance

Linking a workbook to worksheets
 

In physicians workbook in cell B25 apply the below formula

--Edit the workbook name in the below formula
--Assume that the nurses worksheets are named as Sheet1, Sheet2, Sheet3 and
so on...
--Apply the formula and copy/drag the formula down as required

=INDIRECT("'[Nurses.xls]Sheet" & ROW(A1) & "'!$B$27")

If this post helps click Yes
---------------
Jacob Skaria


"Ron Purpura" wrote:

Hello all
Was wondering if anyone has any experience linking worksheets to a workbook.
The problem I am having is that I want to link cell B25 from my (physician)
workbook to cell B27 of a (nurse's) worksheet 1(which is part of another
workbook). I wish to increment the cell to B26 being used in the physian
workbook to link to cell B27 in nurse's worksheet 2 and so on,following the
same pattern.Is this possible?
Thanks much in advance