obad62
asked on
Shared Excel sheet
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
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
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi gyetton,
thank you for your comment, Is there any SQL server app on shelf you suggest?
thank you for your comment, Is there any SQL server app on shelf you suggest?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
alterative soulatuon
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
that means Supervisor should have one excel file contains all staff sheets.