Compare to columns and insert row different sheet

[spoon_009]

Two sheets. Both are almost the same, but in the sheet 2 is missing data. I want where the data is missing in sheet 2 to be fill with new row.
Like that

Sheet 1 Sheet 2
A B A B
1 ccc 1 ccc
2 bbb 2 bbb
3 aaa 4 eee
4 eee
Sheet 1 Sheet
A B A B
1 ccc 1 ccc
2 bbb 2 bbb
3 aaa 3 ___
4 eee 4 eee

PLS help becouse my brain will explode

[Bernie Deitrick]

In C2 of Sheet2, use the formula

=MATCH(B2,Sheet1!B:B,FALSE)-1

and copy down to match your data on sheet2.

Then in the first empty cell of column C, use this array formula (entered using Ctrl-Shift-Enter), replacing the XXXs with the row number of the last row with data on sheet 2:

=MIN(IF(ISNA(MATCH(ROW($C$2:CXXX)-1,$C$2:CXXX,0)),ROW($C$2:CXXX)-1,ROW()-1))

Then copy that down for as many rows as you have on sheet 1.

Then copy and paste values over column C, and sort your data based on column C ascending. Then delete column C

[spoon_009]

Thank you very much. It is not quite what i want ,but my explanation it is not very good. And you help me a lot with the idea.