I am in need of creating an excel spreadsheet which allows my employees to login individually in each sheet and enter in their daily reports. They should only be able to view their own sheets as the other tabs within the spreadsheet would be password protected with the other employees information. I would like the final sheet tab to calculate all of the employees information to get the daily total.
We currently have the layout but we're having trouble password protecting each individual sheet and making sure it is confidential.
If there is an easier way to resolve this, please let us know.
If possible, we would also like to have this file be available from a network computer.