Linking a workbook to worksheets

R

Ron Purpura

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking workbook to multiple worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 0
Identical Cells in Multiple Worksheets in one Workbook. 4
Linking Cells, Incorrect Result 1
how can i calculate a three variable if statement in excel 2
Billable time sheet 2
How do i return data in a cell from the referred cell? 2

Top