Wednesday, December 5, 2012

yogi_Set Up Employee Shannon Spreadsheet For PassWords For Sites For Employees


                                          Google Spreadsheet   Post  #915
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 5, 2012
user rkhubb said(http://productforums.google.com/forum/?zx=k80owd4bepmy#!category-topic/docs/spreadsheets/R5lz2ff4rXM)
Using Filter and ImportRange Function together
I'm a bit of a novice, but can see that this concept should probably work... just not sure exactly how to write the formula.  Here is the situation.

I have a master document with my biz passwords for employees on it, but only want to make some of them visible to certain employees based on there job responsibilities.

I'm thinking that I can have one master list that is only visible to me (lets call it Worksheet A) and all of the info is on a tab labeled "Log in Info".  this sheet would look something like this; ("X indicates that I want them to have access to that rows info).

Site      Log in Link    User Name    Password    Other    Shannon    Alisa
XYZ      xyz.com        name            123             ___       X              __
ABC     abc.com        name 2         1234            ___       __            X
JKL      jkl.com          name 3          12345         ___       X              X

On a separate sheet for both Shannon and Alisa (Worksheet B and C respectively), I simply want to import row 2 and 4 to worksheet B and row 3 and 4 to Worksheet C. 

For the employee template I would like it to reference the employee name that I might put in cell A1 of their sheet, as a query I want it to filter for from the master list; requiring less work from me to manage the new sheet for each employee.  All I would have to do is add the new employee's name to cell A1 of their Worksheet, and on my master list add their name to row 1 and indicate with an x which account info I want them to have access to.

From here I would obviously change viewing permissions for each employee

Does that make sense?  My thought was that I could use Filter and ImportRange functions in combination to pull this off... but I have been grossly unsuccessful so far to make it work.  Any suggestions on how to make this happen.... or even a more simple suggestion that is different?

Thanks in advance for the help!

Keith
--------------------------------------------------------------------------------------------
I don't know how Keith had planned to handle user names ... 
in any event let me present a solution based on my understanding of Keith's intent ... mind you there could be some gaping holes (pun intended) in this strategy.


and similarly, Spreadsheet for Alisa would look like the following  and following is a view of the Master Spreadsheet