Copy Row from closed wordbook to active

[gasper21]

Hi I'm still searching for answer on how to achieve his task. I'm trying to copy a row with title BOE to an open workbook
so the macro has to search for title BOE select the entire row and copy to the open workbook. I have this code however missing the search and copy paste as values.

Can anyone help me please??

Sub copy()


Dim destSht As Worksheet
Workbooks.Open ("C:\test\source.xlsx")
Set destSht = ActiveWorkbook.Worksheets("Sheet1")
With ThisWorkbook.Worksheets("Sheet1")


"MISSING CODE" SEARCH FOR BOE AND SELECT THE ENTIRE ROW COPY TO ACTIVE WORKBOOK as
COPY PASTE AS VALUE

END SUB

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-workbook-copy-open-workbook.html#post5221158

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).