LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to change data validation values based on different passwords

Dear Excel community

I have a problem to resolve asap. I have prepared an excel business case with certain cells having data validation lists. Say I have 12 values in the Validation List picked from a source, but all values are not meant for everyone. I need to create three different users with their respective passwords. First user should be able to see only first 5 values of the list (e.g.) and should be able to select only out of these values. The aecond user should see values 6-9, e.g. and so on.

Appreciate community's kind support.

Cheers
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom data validation on cells with data validation values AKrobbins Excel Worksheet Functions 2 June 21st 11 04:20 PM
Data Validation List - Dependant based on numeric values Roady Excel Discussion (Misc queries) 4 February 12th 10 05:39 PM
Data validation list drop-down values based on prior selections David Excel Programming 2 September 26th 08 03:58 PM
data validation, totaling values based off dropdown lists Jesse Blanchard[_2_] Excel Discussion (Misc queries) 5 September 15th 08 05:15 PM
Data Validation based on range of values jej1216 Excel Programming 2 February 28th 06 03:34 AM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"