Seacowdaz
03-28-2018, 02:12 AM
Hello All.
Firstly I apologise if this has been covered somewhere before, I have searched the internet but due to my rather limited knowledge of Excel VBA have been unable to find something or even modify existing code to meet my requirements.
What I would like is a way of searching a column of data, in this case Column C for a name and then to copy that Cell into the same Cell in Column E.
So searching for John Wayne would copy the contents of Cells C2 and C3 into cells E2 and E3.
The other thing is I would like to search through a range of names rather than one specific one, the list of names in this example would be listed in column J and the amount of names to search would change on a daily basis.
2193921939
Firstly I apologise if this has been covered somewhere before, I have searched the internet but due to my rather limited knowledge of Excel VBA have been unable to find something or even modify existing code to meet my requirements.
What I would like is a way of searching a column of data, in this case Column C for a name and then to copy that Cell into the same Cell in Column E.
So searching for John Wayne would copy the contents of Cells C2 and C3 into cells E2 and E3.
The other thing is I would like to search through a range of names rather than one specific one, the list of names in this example would be listed in column J and the amount of names to search would change on a daily basis.
2193921939