Referencing an Entire Sheet

C

Chaplain Doug

Excel 2002-2003. I have a master workbook that contains 75 sheets. Each
sheet
represents a territory. I have six persons, each of which is responsible for
a subset of these 75 territories. I want to create six workbooks, that
derive their data from the master workbook. Each of these workbooks will
have about a dozen sheets, My question is this: How can I create these six
workbooks such that the sheets in these workbooks point back to the sheets in
the master workbook? I know how to make cells point to cells in other
workbooks. But I want to make the whole sheet point to another sheet in the
master workbook and thereby always duplicate the master sheet. How may I do
this?
Thanks for the help.
 
F

Frank Kabel

Hi
personally this does not sound that Excel is the right application for you.
You may consider using a database for this kind of task
 
C

Chaplain Doug

I need Excel as these sheets to which I refer contain budgets, which in turn
use many Excel formulas. My need still stands. But thanks for replying.
 
Top