insert row and past cell

Sheet2

A B C

1 car
2 hen

i want to copy banana and juice from sheet1 and paste in sheet2

Sheet1

A B C
1 Apple
2 Banana
3 juice
4 cake

two row should be inserted and then pasted on that row


Sheet2

A B C

7 car
8 banana ---- row inserted automatically and banana pasted between car and hen
9 juice ---------row instered automatically and juice pasted between car and hen
10 hen


Thanking you

juzar para