none
How to Control Users to edit RRS feed

  • Question

  • Hi Sir,

    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
    Friday, July 22, 2016 4:56 PM