Hi there, i hope someone can help me?
How do I insert data from another worksheet, based on criteria in the current one?
for instance- worksheet A has 2 columns: "name" and "code" Each name in the "name" column is unique, and has its own code:
Ann, 001
Ben, 002
Claire, 003
In worksheet B I have only the names, but many duplicates. how do i insert, in a seperate column, the code of the name of worksheet A?
so, if the names in worksheet B look like this:
Ann
Ann
Ben
Claire
Ann
The code that is inserted into the row next to the names must be the same code that the names have in worksheet A. Each "Ann" should have the code 001 next to it- for instance.
Many thanks!