title: Compare two different Excel Files and Copy data from one to another if conditions met
body: <p>So I have two files. File1 and File2. Both have the same columns but one is filled and one is not. </p>
  
  <p>What I want to do it if there is a match of name (suppose A1) from File2 in A row of File1 copy the rows Q,R and S to File2.</p>
  
  <p>So if A1 (of File2) is found in A row of File1 (Suppose in A34) then I want to copy Q34,R34 and S34 of File1 to File2.</p>
  
  <p>I think VLOOKUP would be required for the first part so I think that will need to be incorporated in the VBA.</p>
  
  <p>Any help,idea or general direction where I should be heading for would be great.</p>