Updating specific cells based on another file
<p>So I have two excel files and file A is the mother file and file B contains updates to some cells. What I want is to update file A with the updates in file B. Each line in the file has a reference number, that reference number is used to identify which line in file A should be updated.</p>

<p>Basically this is the manual process:</p>

<ol>
<li>Copy the reference number in file B</li>
<li>find the copied reference in file A</li>
<li>go back to file B and copy the adjacent cell (three cells to the right)</li>
<li>paste the copied data in file A in the same cell (three cells to the right)</li>
<li>go back to file B and copy the next reference number</li>
<li>repeat step 2 - 5 until last line in file B</li>
</ol>