hi all, I've a question to ask. I need to gather all data input from different staff in the same excel workbook. I have 3 citeria
1. Staff should not be able to see other staff input.
2. All staff can edit their sheets in the excel file stored in a shared drive
3. Data summary of all different staff input to be shown i another workbook.
May i know if this is possible with excel? I don't want to use access as i am unfamiliar with it.
Bookmarks