Hello all
Hoping to get some insight on linking a workbook to multiple worksheets
My problem is as follows:
I wish to link cell B26 from a workbook named Physician to cell B27 in a
worksheet in a totally different workbook named Nurse1. I am doing this by
simply utilizing the = command.
The real issue is this:
I wish to then link cell B27 from the Physician workbook to cell B27 on a
new worksheet named Nurse2.
I wish to continue this incrementing pattern from the Physician workbook for
many diffenet worksheets.
Is there a way to accomplish this?
Thanks so much in advance
Ron