Hello everyone,
I was trying to merge two worksheets (ws1 and ws2) with an same ID column (in the first worksheet ws1).
I managed this with the following code:
The trouble is that sometimes my ID cells contain two IDs separated by a comma ... And I wondered if it was possible to make a match based on what the cell contains.
Capture.PNG
So if I have an cell X: '' 825634767, 825634766 ''
So when in my other worksheet I have a cell '' 825634767'' and a cell '' 825634766 '', it can apply the same treatment for the two cells that match with my cell X
In my code, the column that can contain an X cell is that of ws2
While my first sheet (ws1) should contain the details (column C) of the ws2 having match.
What do you think please ?
Thank you for reading!
Bookmarks