Using functions to create pin numbers

J

Jeremy

Is there a way I can use a function that will effectively allow me to give
pin #'s to employees so that certain information fills in cells when the pin
# is entered. For example: Multiple employees have access to the document
but only certain employees may enter information into certain cells. Can I
use a function that will allow me to have the specified employees enter a pin
in one cell that will populate their employee number in another cell. So,
continuing with the example, employee 682 is assigned a pin of XYZ. Can I
use a function so that when employee 682 opens the document and enters XYZ in
column B, 682 appears in column A. Hopefully I wasn't too confusing. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top