Before exiting, send info to another separate workbook.

[Legend Rubber]

I am trying to make a "master" sheet where employees total calls for the day are recorded.

Each employee will be marking their calls each day which will be on an excel spreadsheet. i would like to then create a MASTER sheet that links to all the employees specific sheets so when they exit the sheet it updates the master, or it can be a live update if that is possible...

Is this possible?

[Jamie.Reis]

Sure, why not. Do you all have shared network connectivity?

[Legend Rubber]

yes we would all be on the same network.

How is the best way to do this then?

[Jamie.Reis]

Can you provide more information?
Will these people be working from a clean template each day, or amending the bottom of a table with additional data?

How many users?

Create a template for each of the individuals to use and add a button somewhere.
Make that button:
*Open the master file
*Check if the file is ReadOnly - if it is, display a message box showing that another user is currently using the file and to try again momentarily

*Close the file

*If the file is not ReadOnly, copy the used range, paste to the master file
*Save and close the master file

Like:

Please Login or Register  to view this content.