Hi

What I'm trying to do is when I enter a name into one cell the one next to it automatically enters something else.

E.G. Enter someones name in A1 and A2 automaically enters their managers name. Their name and managers name will be in a list.

Any help will be greatly recieved, been trying yo sort out and it making may head spin