I have 2 lists of data and I need excel to go through one list and search for the contents of each cell in the other list and when it finds it, to then copy the cell next to it.
I've started with...
Sheets("Example").Select
MyARange = "A1:A134933"
For each MyACell in Range(MyARange)...