CopyPasteExercise-r1.xlsm

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
Trying to build a macro to perform the following. &nbsp;I have a macro with a variable: strData = Sheets(&quot;Control&quot;).Cells(18<wbr />, 2). &nbsp;What I need is the find a match of strData in Sheets(&quot;Control&quot;) column &quot;M&quot; and once a match is found take the value from Sheets(&quot;Outlook&quot;) cells AA3, AB3, AC3, AD3 AE3 and AF3 and place them in the matching row in column O for the value of AA3, column P for the value of AB3, Column Q for the value of AC3 and so on.
</div>
</div>


Hello, 

Trying to build a macro to perform the following.  I have a macro with a variable: strData = Sheets("Control").Cells(18, 2).  What I need is the find a match of strData in Sheets("Control") column "M" and once a match is found take the value from Sheets("Outlook") cells AA3, AB3, AC3, AD3 AE3 and AF3 and place them in the matching row in column O for the value of AA3, column P for the value of AB3, Column Q for the value of AC3 and so on.

Paste Values

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