Hi, I have a range of names in a list (A2 through G5). i am trying to do the following, If I have the name Peter in Cell C4 and I click on C4 I want the name Peter to appear in Cell A1. I would also like to be able to then click on the word Gary in Cell G2 and Gary would replace Peter in A1.
If anybody has any ideas as to how I can do this or point me in the right direction I would be most grateful.
Thanks
Peter
If anybody has any ideas as to how I can do this or point me in the right direction I would be most grateful.
Thanks
Peter