|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Duplicate . Thread closed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I get Outlook from one user to another w/o a .pst file (primary user on computer is corrupt) | Tenmakk | Outlook | 0 | 03-01-2015 12:49 PM |
Moving appointments from one user's calender to another, with the ability for user to | samgraham1975 | Outlook | 0 | 02-04-2014 07:20 PM |
Mail merge with filter using data inputted by user | Tornado70 | Mail Merge | 6 | 04-09-2013 07:16 AM |
Edit Multiple Emails' User-Defined Field | ryancaseymcshane | Outlook | 0 | 10-04-2011 07:40 AM |
User seeing other user's color categories | MTFysherman | Outlook | 0 | 11-13-2008 04:36 PM |