Old.xlsx

New.xlsm

<div>
<div class="content wysiwyg-content">
So I've got two excel spreadsheets that have a column with a unique ID in it. &nbsp;They also both have two other columns in common. &nbsp;In one sheet, the two columns have data, the other I'm manually filling in from the first.<br />
<br />
Is there a way to merge\import the data from one sheet to another by the unique ID they have in common
</div>
</div>


So I've got two excel spreadsheets that have a column with a unique ID in it.  They also both have two other columns in common.  In one sheet, the two columns have data, the other I'm manually filling in from the first.

Is there a way to merge\import the data from one sheet to another by the unique ID they have in common

Merge Excel Documents

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