Hello, I am running Excel 2011 on a Mac and I am currently working on a systematic review paper of some scientific literature. I had to catalog a larger search as two smaller searches, and so I now have two separate lists that I have to align to the main list (which doesn't have all the supplementary data I need).

The main list that I want to align the data to is on the left. On the right are the two searches put together to make a master search. Unfortunately, there is a slight difference in the number of results in each list. The main (correct) list has 588, while the two searches put together have 592. My hope is that after alignment, the four entries that don't belong can just be thrown out. Here is how my spreadsheet is organized (row E is blank).

A---------B---------C----------D---------E--------F---------G-----------H--------I--------J--------...more data
1--------yr1----author1----journal1---|---------yr10----auth142----journal32-----PROJECT DATA
2--------yr1----author2----journal2---|---------yr5-----auth284----journal15-----PROJECT DATA
3--------yr2----author1----journal3---|---------yr9-----auth312----journal28-----PROJECT DATA
4--------yr3----author3----journal3---|---------yr12----auth13-----journal42-----PROJECT DATA

Every entry on the left has a match on the right, but not every entry on the right has a match on the left. Can someone please help me with a VBA program that will match the entries on their right to the correct order as shown on the left?

Thank you very much in advance!