<div>
many thanks Have a great Christmas and New Year
</div>


many thanks Have a great Christmas and New Year

<div>
<div class="content wysiwyg-content">
Hello experts. not been able to find the exact code I need so looking for your help, again<br />
<br />
I need to find the word Counterparty Code in column A and then from that point copy A-D to the last cell that is not blank<br />
<br />
so if Counterparty Code is found in A7 and the last non-blank cell is A200 I need to copy the range A7 to D200 <br />
<br />
many thanks
</div>
</div>


Hello experts. not been able to find the exact code I need so looking for your help, again

I need to find the word Counterparty Code in column A and then from that point copy A-D to the last cell that is not blank

so if Counterparty Code is found in A7 and the last non-blank cell is A200 I need to copy the range A7 to D200 

many thanks

find text then copy a range

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