Is there any way to reference a worksheet from a saved
file in entirety to another file other than manually
keying in the references and then filling in all the cells?
Here is what I want to accomplish. File A has 10
worksheets. The first 3 of these do not need to be secure,
but the remaining 7 do, and are based on the first 3. I
would like to give individuals access to these first 3
sheets for input purposes, but not to the secure
information. I thought this might be accomplished by
creating a second workbook with just the first 3 input
pages, and then have the first book precisely reference
those 3 pages, as shown below.
Workbook AWorkbook B
page 1page 1
page 2page 2
page 3page 3
page 4-10
Thanks,
Pradhan