roelandwatteeuw
Board Regular
- Joined
- Feb 20, 2015
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Hi all
Hope you can help me with this one:
I have a list A with data.
List A:
<tbody>
</tbody>
Now I got a new list B with more data. They have the same columns, same data, only the column 'Comment' will be blank. BUT: Not all the lines from list A will be in list B and the other way around.
I paste these lines under the lines from list A.
List B:
<tbody>
</tbody>
I need to combine these two lists to one unique list.
Conditions:
1. All the lines (ID-nr) from list A that are not in list B, need to be deleted in list A
2. All the lines from list B that are in list A, need to be deleted in list B
The results should be:
Result:
<tbody>
</tbody>
What would be the best way to do this?
VBA-code?
Thank you!
Roeland
Hope you can help me with this one:
I have a list A with data.
List A:
ID-nr | Address | Meters | User | Comment |
1 | Street A | 123.4 | Marc | OK |
2 | Street B | 56.7 | Rob | Problem |
<tbody>
</tbody>
Now I got a new list B with more data. They have the same columns, same data, only the column 'Comment' will be blank. BUT: Not all the lines from list A will be in list B and the other way around.
I paste these lines under the lines from list A.
List B:
ID-nr | Address | Meters | User | Comment |
2 | Street B | 56.7 | Rob | |
3 | Street C | 89.1 | Frank |
<tbody>
</tbody>
I need to combine these two lists to one unique list.
Conditions:
1. All the lines (ID-nr) from list A that are not in list B, need to be deleted in list A
2. All the lines from list B that are in list A, need to be deleted in list B
The results should be:
Result:
ID-nr | Address | Meters | User | Comment |
2 | Street B | 56.7 | Rob | Problem |
3 | Street C | 89.1 | Frank |
<tbody>
</tbody>
What would be the best way to do this?
VBA-code?
Thank you!
Roeland