Row-Level Security: Different rows for different users

Hi PJ_Canuck , 

The solution you are looking at requires you to select a range, add a password for that range, then give the password to whoever you want to edit that specific range. You can have many ranges, each with its own password. If you want to expand a range (as in adding another assignment) you must repeat the process. To me, that's a lot of work. 

An alternative without VBA programming is to give each team member their own, identically laid out workbook which they would store in their private directory so no one else has access. The workbook would include a user specific Power Query (PQ) query which would pull their assignments from your master (you must grant read-only-access to each team member) into their workbook. Each team member would then make entries into their workbook. Your master workbook would then use a PQ query to poll each team member's worksheet and consolidate data. 

Pros: 

• No one can alter anyone else's data.
• Everyone can be in their workbook at the same time.
• Team members only see what pertains to them
• Polling team member workbooks is a matter of clicking Data > Refresh All on the master
• No VBA required
• No passwords required

Hope that helps.