Hi,
I have an Excel file which have to be in collection department. This department contains 30 guy in 3 groups reporting to one director.
So the management hierarchy is three levels.
I want that Excel sheet to be as a check list or end of day report in front of all staff. by end of day each group has to fill this form and send it by clicking one button
It will go to his supervisor. all three supervisor has to review all of them plus their own reports and accept to flow to the manager or reject so
agent can amend. I want user can not amend or change any cell except what I left a comment to you.
All of theme are using a Lan and they are using a shred drive. Attached the file. DCFC-Collection.xls
they are not going to use the same file at the same time. End of day each user has to fill his sheet and press a button (send ) so his supervisor can see his sheet, accept or reject with comments.
that means Supervisor should have one excel file contains all staff sheets.
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
ASKER
that means Supervisor should have one excel file contains all staff sheets.