Is there a way to write a Macro that will look at Sheet 1 and look up the value in D3 and see if it is in Columns F to O in Sheet 2 and if there are matches copying and pasting that whole row from sheet 2 onto sheet 1 at A15. After copying pasting all the ones that matched with D3 than starting with D4 and doing the same thing until D7?