Insert row based on criteria in EXCEL

[Closed]
Report
-
hi friends,

i'll get same data in two different sheet with a small changes, i will compare sheet one and sheet two, to create new sheet

eg.

(car parts)
sheet One will contain data like

part number | make | year | model
0aad22658 | RAM | 2016 | 1500
0aad22658 | RAM | 2015 | 1500
0aad22658 | RAM | 2014 | 1500

(car parts)
sheet Two will contain data like

part number | make | year | model
0aad22658 | RAM | 2016 | 1500 regular cab
0aad22658 | RAM | 2016 | 1500 extended cab
0aad22658 | RAM | 2016 | 1500 crew cab
0aad22658 | RAM | 2015 | 1500 regular cab
0aad22658 | RAM | 2015 | 1500 extended cab
0aad22658 | RAM | 2015 | 1500 crew cab
0aad22658 | RAM | 2014 | 1500 regular cab
0aad22658 | RAM | 2014 | 1500 extended cab
0aad22658 | RAM | 2014 | 1500 crew cab

in this,

> sheet one will give information about main model like "1500"
> in sheet two i'll get information about sub model also, like "1500 regular cab, 1500 extended cab, 1500 crew cab" fore the same part number.

sheet Three i will take a part number in sheet one, and i'll check in sheet Two, to know weather i should insert NEW ROW.

so i would like to know, insert new lines based on criteria automatically.

please some one help me in this, i'm spending couple of weeks to complete single project.