Multiple Workbooks HELP Please

[daleholden]

Hi
I need to know if i can upgrade data from 1 workbook to another on the same machine.

I have a master workbook with several sheets i use. Sheet 1 is the main database for me to record work my staff complete.

The fields are simple Date of incident Date allocated Name Address several more and Date Submitted back to me.

On the other sheets i have pivot tables and graphs on others.

QUERY

When i go on holiday i copy my sheet 1 the main database to another workbook. I have a assistant who enters new data and updates old data with Date returned. Is it possible to update my main datatbase with the date he is adding to the copy workbook.

Hope that makes sense, it would save me having to copy and paste the temp sheet into the main database.

Cheers Dale

_________________
People prefer to follow those who help them, not those who intimidate them.
This message was edited by daleholden on 2002-09-23 18:17

 

[jimboy]

You could copy all data in sheet1 (with new data) and Paste special > Paste Link into your other workbook (old data) and then in what was the old data copy > paste special > values over the new data.

 

[daleholden]

Sorry can you explain a little clearer it sounds very confusing that.

 

[DonkeyOte]

The other way of doing this - (which would mean starting something new but that would solve these problems once and for all) - would be to create a template. You can use either a template wizard or you could code a similar process yourself. The basic premise being that you have one template that contains all the fields you want to appear in your database; when someone enters information and then saves the template it posts the data as a new line in your database. ie. you would only need one template (for both you and your staff to use to update the dbase), yet you could then run off your pivots etc from the database (within the new database file).

Make sense?

 

[jimboy]

Select the range, copy, select the first cell in the new workbook, and right mouse over it, select paste special > paste link or values.