INserting a worksheet from one workbook to another workbook

I have a workbook with 12 worksheets in Excel 2000. Each worksheet relates to
a department (these are to do with hours)

I want to create 12 different workbooks, one for each department, and have
the data from the relative departmental worksheet in the original workbook
inserted into the new workbooks. These also, if possible, need to be updated
when the user opens them whenever the original user updates the master.

I've tried embedding a linked object in the new workbook and selecting the
master workbook...but when the user double clicks on the "inserted"
worksheet, it opens the master workbook and shows ALL the worksheets.

I've also tried protecting the master workbook...for some reason this
doesn't work...nor does it ask me for a password (is it because I'm using it
on the machine I opened the master on??!)

Does anyone know how to go about this?

Really stuck. Any help appreciated

In each satalite workbook, you can put this formula in A1
='C:\[MasterFile.xls]Dept1'!A1

Copy down and across as needed and change the Dept number for each different
satelite book.....


Vaya con Dios,
Chuck, CABGx3





"Billy" wrote:

> I have a workbook with 12 worksheets in Excel 2000. Each worksheet relates to
> a department (these are to do with hours)
>
> I want to create 12 different workbooks, one for each department, and have
> the data from the relative departmental worksheet in the original workbook
> inserted into the new workbooks. These also, if possible, need to be updated
> when the user opens them whenever the original user updates the master.
>
> I've tried embedding a linked object in the new workbook and selecting the
> master workbook...but when the user double clicks on the "inserted"
> worksheet, it opens the master workbook and shows ALL the worksheets.
>
> I've also tried protecting the master workbook...for some reason this
> doesn't work...nor does it ask me for a password (is it because I'm using it
> on the machine I opened the master on??!)
>
> Does anyone know how to go about this?
>
> Really stuck. Any help appreciated