Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2022, 07:42 AM
User5678 User5678 is offline Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Windows 11 Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Office 2021
Novice
Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr
 
Join Date: Nov 2022
Posts: 1
User5678 is on a distinguished road
Cool Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr


I'm working to find a solution to the following:

6 to 12 New Hires receive onboarding training over a two-month period
Multiple Trainers input evaluation data over that period of time
Supervisors need access to that data

I've been looking into utilizing Excel with multiple sheets. See the screenshot below for further explanation.
https://i.im.ge/2022/11/22/SDauwq.On...-for-Forum.png

I'm finding youtube videos describing different ways of hiding and restricting tab access but is this is the best way of approaching this problem?

Thanks for your help!
Reply With Quote
  #2  
Old 11-23-2022, 12:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Windows 10 Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,653
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

Hi and welcome
for best help please post a sample sheet ( no pics please) on the board ( external links are unsafe) with some data and manually calculated expected results. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-23-2022, 06:32 AM
ArviLaanemets ArviLaanemets is offline Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Windows 8 Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Office 2016
Expert
 
Join Date: May 2017
Posts: 762
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

One possible solution:
In your LAN, you have a folder on some network resource. This folder has subfolders with access limited to person(s) entering new employees, to specific trainers, and to specific supervisors.

In employees registering subfolder you have a workbook with a table of employees in one sheet, and with table of training schedules in second sheet, where is determined which trainings the employee must have;

In every trainer's subfolder, you have a copy of workbook, where trainer can register his/her training sessions, and their results with trainees. The list of current trainees is on hidden sheet, and is read from employees registering workbook by an ODBC query. This table is a source for data validation list for selecting trainees into training registry table(, and probably as source of any additional info about trainees);

In every supervisor's subfolder, you have a copy of another workbook, where supervisor can see training results of his/her trainees. To get this info, the workbook has hidden sheets, which use ODBC queries to read needed info form employee registering table, and from trainings tables for every trainer. The info from those hidden sheets is used to calculate the training reports the supervisor needs.
In case supervisors also have to enter some information, their workbooks get somewhat more complex - in his/her working table the supervisor has to register the trainee at first, and only after that he/she can get any training info about this trainee. And any info he/she is entering, must be entered into same row where he/she registered the trainee;

In case there is a need to get some info back e.g. from trainer's workbooks into employees registering workbook, or from supervisor workbooks to trainers workbooks, etc., this info also must be read using ODBC queries into specific hidden sheets, and then read from there by formulas into visible tables.

With such system, all users can work without affecting other users. Queries are set to be refreshed on opening (optionally after some time interval too), and user can always force data refreshing too. The changed data in any workbook will be available to querying after the workbook is saved (Queries read data from file on network resource. When user opens a workbook and works with it, it happens in user's computer memory only, and all changes to file on resource - e.g. on data server folder - are done when the file is saved).
Reply With Quote
Reply

Tags
multiple users, restrict access

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows 10 Home: Data Sharing Service xyz-bbc-aot Office 0 08-29-2020 12:31 PM
Streamline input, sharing, and protecting data for New Hire Evaluations among Evaluators & Mngr Formula to work out equipment hire based on a minimum hire period. mpaino Excel 7 07-18-2016 04:08 AM
Outlook 2013 deletes all calendar data upon sharing to WebDAV server kabimaus Outlook 0 01-25-2016 03:08 AM
Sharing data between Office applications mdavies Office 1 11-26-2013 02:55 PM
Sharing the data pengyou Outlook 0 04-06-2010 09:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft