create local copy (of only some cells) of spreadsheet on network

  • Thread starter Thread starter topstar
  • Start date Start date
T

topstar

Folks,

Our office has a workbook having monthly schedules of tasks for th
team. There is a workbook for each year, and each workbook has 1
worksheets - for each month. Each workbook contains months from Jan t
Dec.

So basically there is a workbook - Schedule2004.xls contains 1
worksheets Jan04 to Dec04

The first row in each worksheet contain the names of team members a
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
 
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.
 
Back
Top