I have two workbooks (ResultMatch) and (Data Source). Want to search second workbook (Data Source) for row based on matched OrderId (found in each workbook) then with found selected row from (Data Source) paste back to first workbook (ResultMatch) importantly, append found data on same row as a matched OrderId.
Attached is a simplified sample of the workbooks. The example shows intended result in green in the ResultMatch wbook. Would operate from a button located on the ResultMatch wbook.
Any code help really appreciated.