Modify macro that matches columns on two different sheets to return entire row of match

I have a "matching" macro (below) that works well with large data sets when it finds a match it will return the a partial row, from the matched cell to the last cell in that row.

I need it to return the entire row of the matched cell, I have tried to figure this out but have had no success.

I have attached a simple workbook.

Thank you for you consideration.

Please Login or Register  to view this content.

Thank you AB33 this this most helpful!!