Hi there!
I need help with a formula or something like that in Excel 2010.
What I want to be able to do is:
When I choose a name from a dropdown list in a random cell in one coloumn, I want that name to be coupled up with that name's employee number etc. So when one employee opens this shared document, he/her will be able to put in his/her number in a (random) cell adjacent to his/hers name, and the third cell will then automatically show their signature (their name in a different colour etc)
This code must be able to be used in many cells, in many different sheets. And there has to be one sheet with all the names and numbers in that I can hide.
Here's what I have tried:
Malformed Images Removed
The names in Sheet 1, (Module 01) is names that is taken by using dropdown list from sheet 2 (Instructors).
When I chose "Tom" from dropdown list and enter his code 222 in adjacent cell his signature comes up whit this code. When I enter "Hans" and his code in adjacent cell his signature comes up. But it stops there.. I want to be able to chose whomever from the dropdown list, write that persons number and magically show their signatures. If the wrong number is entered, there will be shown a blank cell.
Hope someone can help me!
I need help with a formula or something like that in Excel 2010.
What I want to be able to do is:
When I choose a name from a dropdown list in a random cell in one coloumn, I want that name to be coupled up with that name's employee number etc. So when one employee opens this shared document, he/her will be able to put in his/her number in a (random) cell adjacent to his/hers name, and the third cell will then automatically show their signature (their name in a different colour etc)
This code must be able to be used in many cells, in many different sheets. And there has to be one sheet with all the names and numbers in that I can hide.
Here's what I have tried:
Malformed Images Removed
The names in Sheet 1, (Module 01) is names that is taken by using dropdown list from sheet 2 (Instructors).
When I chose "Tom" from dropdown list and enter his code 222 in adjacent cell his signature comes up whit this code. When I enter "Hans" and his code in adjacent cell his signature comes up. But it stops there.. I want to be able to chose whomever from the dropdown list, write that persons number and magically show their signatures. If the wrong number is entered, there will be shown a blank cell.
Hope someone can help me!
Last edited by a moderator: