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
How do I link a cell in a workbook? 1
Visio to Excel 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Syncing between source worksheet and dependent worksheets 0
VBA Coding Help for Beginner 0
Billable time sheet 2
Identical Cells in Multiple Worksheets in one Workbook. 4

Top