Open another workbook find match copy row to open workbook.

Hello, I found some code that generally does what I want it to do but I need to open another workbook as the source rather than a sheet from the active workbook. I keep reading that I can't have two active workbook so not sure how to adapt this code.

Please Login or Register  to view this content.

The source workbook is always in the same directory with a name that doesn't change. Also I'd like to change the C value to the value of a cell in the destination worksheet.

Thank you for taking the time to read this and for any help or advice.

Code has to run from target or source workbook ?

Kind regards
Leo

Originally Posted by skyblues

... I need to open another workbook as the source rather than a sheet from the active workbook ...
The source workbook is always in the same directory with a name that doesn't change.

???
Try, adapt code:

Please Login or Register  to view this content.

Originally Posted by skyblues

...Also I'd like to change the C value to the value of a cell in the destination worksheet.

Which cell (you are copying the entire row of cells) ?

skyblues,

Perhaps
1) If other Source workbook is open

Please Login or Register  to view this content.

if not open

Please Login or Register  to view this content.

2) If you want to change criteria, i,e, 17513 to cell reference then something like

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind regards
Leo

Thank you all for the replies. I will look at in more detail.