CharlieRog
New Member
- Joined
- Sep 13, 2019
- Messages
- 14
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)
Sheets("Example").Select
If MyACell.Value =
But not sure how to define value as a multi value variable. E.g range from start to end of list
I've started with...
Sheets("Example").Select
MyARange = "A1:A134933"
For each MyACell in Range(MyARange)
Sheets("Example").Select
If MyACell.Value =
But not sure how to define value as a multi value variable. E.g range from start to end of list