On Sheet1 I have 5 cols A to E. At any stage when I activate a cell (any row)
in Col A, by pressing a macro key or other button, I would like the program
to switch to Sheet2 to give me an option the select say, the name in Col A
and the age in Col E. I would like to obtain this without scrolling through
500 names on the list, if possible. Once allocated on Sheet2, I want to place
the selected name and age into Sheet1 in Col A and Col E respectively (note
the cells on Sheet1, B,C and D are blank). Can anyone help?