Try this
1/. Copy all the data, including the headers, from Sheet 100 to Sheet3
2/. Copy the data, excluding the headers, from Sheet 200 to Sheet3 to first free row
With Sheet3
3/. Sort on column A
4/. Copy the headers to M1
5/. In M2
Drag/Fill down to the end of the data
6/. In N2
Drag/Fill across to the last header column
Then Drag/Fill down to the last used row.
7/. Copy this all of new table and Paste Special > values to A1
8/. Delete the formula table
9/. Filter Column A for blanks
10/. Select all of the resultant rows and Delete > Delete Sheet Rows
11/. Remove the filter and it's done.
This takes less time to do than explain, or indeed, read!
I have set up a table in the attached workbook (up to step 7) to let you see the method.
You can take it from there.
Hope this helps.
Bookmarks