Relevant user should see only his data

Discussion in 'Excel' started by Cherry4u, Jul 23, 2016.

  1. Cherry4u

    Cherry4u

    Joined:
    Jul 23, 2016
    Messages:
    1
    Likes Received:
    0
    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
     
    Cherry4u, Jul 23, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ashok
    Replies:
    0
    Views:
    478
    ashok
    Feb 25, 2011
  2. DPCpresto
    Replies:
    0
    Views:
    242
    DPCpresto
    Apr 6, 2012
  3. Josephine Gooi

    Data link properties

    Josephine Gooi, Apr 23, 2012, in forum: Excel
    Replies:
    0
    Views:
    663
    Josephine Gooi
    Apr 23, 2012
  4. hunnja

    Macro for manipulating data

    hunnja, Apr 25, 2014, in forum: Excel
    Replies:
    0
    Views:
    588
    hunnja
    Apr 25, 2014
  5. tcebob

    Sum data using sumif

    tcebob, Jan 26, 2016, in forum: Excel
    Replies:
    3
    Views:
    217
    tcebob
    Jan 29, 2016
  6. TryllZ
    Replies:
    4
    Views:
    229
    XLPadawan
    Jun 9, 2016
Loading...