Old.xlsx

New.xlsm

<div>
That worked amazingly well! &nbsp;Thanks for the help.
</div>


That worked amazingly well!  Thanks for the help.

<div>
Thanks, FHS-Tech, glad to help.
</div>


<div>
<div class="content wysiwyg-content">
I have two spreadsheets: New and Old. &nbsp;Both have a column B labeled &quot;Record ID&quot;. &nbsp;I would like to be able check if B2 &quot;Record ID&quot; in Spreadsheet New exists in column B of Spreadsheet Old and if it does, copy the contents from C2 of Old Spreadsheet into C2 of New spreadsheet.<br />
<br />
Excel 2010<br />
Windows 7 <br />
<br />
Any takers?<br />
<br />
Muchas Gracias!
</div>
</div>


I have two spreadsheets: New and Old.  Both have a column B labeled "Record ID".  I would like to be able check if B2 "Record ID" in Spreadsheet New exists in column B of Spreadsheet Old and if it does, copy the contents from C2 of Old Spreadsheet into C2 of New spreadsheet.

Excel 2010
Windows 7 

Any takers?

Muchas Gracias!

Excel: copy contents of one cell from one file into a cell of another file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.