Topstar,
If you want a copy of part of a sheet, you might want to link to the sheet
containing the data. To do that, create the local workbook, open the main
one, select and copy the cells, switch to the local one, Edit - Paste
Special - Link. This probably won't work as is if there isn't a drive on
the local machine mapped to the network drive.
Or you can take a copy of the main workbook, delete all you don't want,
and save under the local location and filename. Or copy/paste just the
stuff you want to a local workbook. This will be static data -- a snapshot;
it won't change when the main workbook changes.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"topstar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Folks,
>
> Our office has a workbook having monthly schedules of tasks for the
> team. There is a workbook for each year, and each workbook has 12
> worksheets - for each month. Each workbook contains months from Jan to
> Dec.
>
> So basically there is a workbook - Schedule2004.xls contains 12
> worksheets Jan04 to Dec04
>
> The first row in each worksheet contain the names of team members as
> headings - Date, Mike, Dale, Peter, Angela etc
>
> From the second row is the data, for ex as shown 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
|
Similar Threads
