I have two worksheets, some headings are the same, some not. I have to merge
them into a new worksheet, for example:

1st Worksheet:

Province City Number of Sales
ON Toronto 51
ON Ottawa 44
NY New York 101

Another worksheet:

Province City Number of books
ON Kingston 1345
ON Ottawa 34343
NY New York 56575
QUE Montreal 33434

Merge to a new worksheet:

Province City Number of Sales Number of books
ON Toronto 51
ON Ottawa 44 34343
NY New York 101 56575
ON Kingston 1345
QUE Montreal 33434


The way I used was pretty tedious.

1. Intert Columns, make sure both of worksheets have the same structures.
2. Copy one sheet into another sheet, then sort by "City"
3. Then intert one more column, and fomula" =if(B2=b1, 0,1)" to check the
duplicates.
4. Check all "0"s, manually copy the data, make sure all of the data entered
into the same row. After merge one row, then delete the row above.....

Is there any way to speed up the whole process. Thanx!