mmj1

<div>
Thank you so much!!! &nbsp;That worked great!!
</div>


Thank you so much!!!  That worked great!!

<div>
You're welcome! Glad it worked as desired.
</div>


You're welcome! Glad it worked as desired.

<div>
<div class="content wysiwyg-content">
In am on Excel 365 and I have two separate excel documents, i.e.<br />
Document 1 has data entered in column &quot;F&quot;<br />
Document 2 does not have data entered in column &quot;F&quot;<br />
<br />
Wondering if there is an easier way other than manually to do the following:<br />
<br />
If the data in Document 1 column &quot;B&quot; matches the data in Document 2 column &quot;B&quot; - populate column &quot;F&quot; on Document 2 with the data from column &quot;F&quot; on Document 2<br />
<br />
Thank you!
</div>
</div>


In am on Excel 365 and I have two separate excel documents, i.e.
Document 1 has data entered in column "F"
Document 2 does not have data entered in column "F"

Wondering if there is an easier way other than manually to do the following:

If the data in Document 1 column "B" matches the data in Document 2 column "B" - populate column "F" on Document 2 with the data from column "F" on Document 2

Thank you!

Excel 365 Help

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.