R
regepxw
I have two lists of names. The first is classified as a range e.g.
“Present”. The other is not a range, but I will refer to it as ‘New’.
New is imported daily. I want to compare each of the names in the New
list with the Present range. I can do this the MATCH(A1,Present,0)
reference for the name’s occurrence in Present. If the name is not
present then I get error #N/A returned, which I think is Error 2024
In VBA I have managed to select the names that have a numerical value
returned by the MATCH and copy them to a new table. I can not do this
where the return is the error.
The aim at the end is select:
1) Copy the names from New AND in Present to another table.
2) Copy the names from New NOT in Present to another table.
3) Automatically add the names from New, with other relevant cells, but
not in Present, to the end of the list in Present, and sort
alphabetically.
Hopes this makes sense.
Many Thanks.
Peter
“Present”. The other is not a range, but I will refer to it as ‘New’.
New is imported daily. I want to compare each of the names in the New
list with the Present range. I can do this the MATCH(A1,Present,0)
reference for the name’s occurrence in Present. If the name is not
present then I get error #N/A returned, which I think is Error 2024
In VBA I have managed to select the names that have a numerical value
returned by the MATCH and copy them to a new table. I can not do this
where the return is the error.
The aim at the end is select:
1) Copy the names from New AND in Present to another table.
2) Copy the names from New NOT in Present to another table.
3) Automatically add the names from New, with other relevant cells, but
not in Present, to the end of the list in Present, and sort
alphabetically.
Hopes this makes sense.
Many Thanks.
Peter