Thread: Excel to be edited by multiple user but relevant user should see only his data
View Single Post
 
Old 07-22-2016, 02:30 AM
dolphine4u dolphine4u is offline Windows 10 Office 2013
Novice
  
Join Date: Jul 2016
Posts: 3
dolphine4u is on a distinguished road
Default Excel to be edited by multiple user but relevant user should see only his data
Hi Experts,
Need your help pls
I have an excel with below info in A, B, C & D columns

A B C D
Sulphonator InvoiceNumber Ext.Qty Req.Qty
Anil 12345 100
Kumar 34567 78
Sam 93748 56
Anil 823423 12
Sam 8918 786

My requirement is that i have placed this excel on shared drive and given access to users mentioned in column A.
If Anil opens the workbook he should be only allowed to edit column D where his name is in column A and reset cells should be locked / should not allow to be edited.
Ex: Anil name is seen in Sulphonator column in line 1 & 4 so he should only be able to enter Req.Qty in row 1 & 4.

TIA