excel - Getting corresponding data from another sheet -

I'm new with no good on Excel and VB, and could not find any way to solve the following: I Is a sheet that contains data about the articles and another sheet containing the title of the article and the quantity of that time.

For example, the first sheet contains data in these columns:

  The first author is the second author, the other author publication year title more information published in  

and second of these:

  title count  

I want to copy all the data from the first sheet to the second sheet on the first sheet ( Based on the title of the article) some titles can appear twice on the first sheet, but only copy once Hey there. Also, it would be nice if all the rows copied from the first row to the second line would be highlighted, which would make me a mistake or not.

A VBA solution is also welcome.

No need for VBA This is a simple INDEX-MATCH combination is.

Set-up:

Sheet1:

sheet 2:

Sheet2! Insert in C2, drag down and right:

  = INDEX (sheet 1! $ A: $ G, MATCH (sheet2! $ A2, sheet 1! $ E : $ E, 0), match (sheet 2! C $ 1, sheet 1! $ A $ 1: $ g $ 1,0))  

Result:

let us know this That it helps.