Is this Possible

  • Hi Experts,


    Is this possible
    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

  • Re: Is this Possible


    http://www.ozgrid.com/forum/showthread.php?t=104194


    Quote

    The person coming here for help MUST state the amount (including the currency) they are offering in their thread title.

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: Is this Possible


    I will close this thread as I see you started a new thread with the value in the thread title. Please ensure you pay 10% to ozgrid, as per instructions on the first line here -


    http://www.ozgrid.com/forum/showthread.php?t=104194


    Regards
    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!