get an area of the workbook to appear in another

[topstar]

I am sorry, my last post had an unrelated subject line for the below,
am posting it again, with the hope that it might invoke the curiousit
of some more people.

--

Folks,

Our office has a workbook which schedules my teams tasks. There is
workbook for each year, and each workbook has 12 worksheets - for eac
month. Each workbook contains months from Jan to Dec. So the workbook
Schedule2004.xls contains 12 worksheets Jan04 to Dec04

The first row in each worksheet contain headings - Date, Mike, Dale
Peter, Angela etc From the second row is the data, for ex as show
below

Date Mike Dale Peter Angela
01/01/04 coding coding testing documentation
02/01/04 coding coding testing documentation
03/01/04 coding coding testing documentation
04/01/04 coding coding testing documentation

 

[Trevor Shuttleworth]

But what do you want to do ? Another what ?

Regards

Trevor

 

[BrianB]

I suppose that no-one can see what the problem is. In the absence o
other replies :-

The simplest method would be for your users to open the workbook, mak
a local copy via SaveAs, and hide or delete the unwanted columns