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...