If Column U=Yes, copy entire row onto first blank row of new sheet

Hi all,

I'm trying to create a macro so that when you push the button on sheet "Meter List" it will copy any row from sheet "Index" that has Yes selected in the dropdown in Column U, and put that information starting in the first blank row which is Row A14 on the same sheet as the button

I have an example workbook with two dropdowns in a row. The code I tried so far is

Please Login or Register  to view this content.