Avatar of obad62
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
Microsoft ApplicationsMicrosoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
obad62
SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of obad62
obad62

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of gyetton
gyetton
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
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.
Avatar of obad62
obad62

ASKER

Hi gyetton,

thank you for your comment, Is there any SQL server app on shelf you suggest?
SOLUTION
Avatar of gyetton
gyetton
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
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.
Avatar of obad62
obad62

ASKER

alterative soulatuon
Microsoft Excel
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo