Hi guys. I have a new problem that I hope you can help me out.
In my workbook I have three ranges of data. Each range contains 4 columns. I would like to merge the values from B:E with L:O only if the name in col B cannot be found in col L. All the names that can't be found will be added in the L:O list in a new range T:W. Where I would also like the data to be sorted alphabetically. A sample with an expected result has been made
Hope this makes sence and thanks for looking into it.
Alex
Bookmarks