Hi guys, I need to take in third sheet all data which are missing in second sheet from first sheet, for example:
ID Name LastName
1 John Doe
2 Jany Tine
3 Paull Marphy
4 East Doe
5 West Marlyn
6 Thirstan Wist
7 Second East
8 Example Middle
9 Doe Tryer
10 Marlyn Early
Sheet 1
ID Name LastName
1 John Doe
4 East Doe
9 Doe Tryer
10 Marlyn Early
Sheet 2
And in Sheet 3 to get result
2 Jany Tine
3 Paull Marphy
5 West Marlyn
6 Thirstan Wist
7 Second East
8 Example Middle
Sheet 3
Thank you
Bookmarks