daleholden
Board Regular
- Joined
- Sep 22, 2002
- Messages
- 243
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
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