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

[soldevi53]

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.

[soldevi53]

First code wasn't even close, trying this now, the code executes but nothing is copied, seems im missing the part to focus on sheet "Index"

Please Login or Register  to view this content.

[arlu1201]

Were you able to get a solution to this?

[watersev]

hi soldevi53, option using Autofilter method, please check attachment, press "Populate Meter List" button

Please Login or Register  to view this content.