Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! How Do I Do This???
Each person in my dept (approx 10 people) are assigned codes that they are
responsible for. For example: John Smith's codes are 080, 116P and 114. Jane Doe's codes are 115AB, 11D, 10PI and 1586D, etc.) If someone needs to get information on someone else's code, we send them an email. To eliminate having to send emails, I'd like to create a shared worksheet that allows each of us to type the code needing information in column A. I'd like the cells in column B to automatically fill in the person that's responsible for the code typed in column A. So, if I type the following in column A, it will provide me with info in column B (A1) 11D (B1) Jane Doe (A2) 116P (B2) John Smith This will tell Jane Doe to provide whatever info is needed on her code 11D and John Smith will provide whatever info is needed on his code 116P. I basically want to do something like conditioning formatting. Thanks for any help anyone can give me. |