Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 07-22-2016, 02:30 AM
dolphine4u dolphine4u is offline Excel to be edited by multiple user but relevant user should see only his data Windows 10 Excel to be edited by multiple user but relevant user should see only his data Office 2013
Novice
Excel to be edited by multiple user but relevant user should see only his data
 
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
  #2  
Old 07-24-2016, 12:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel to be edited by multiple user but relevant user should see only his data Windows 7 64bit Excel to be edited by multiple user but relevant user should see only his data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Closed Thread

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft