Copy certain data from Sheet1 to Sheet 2 based on values in a column on Sheet1

Hi Experts,

I have tried looking, but cannot find what I am trying to do. I have found some that are close, but cannot get it to work. I am trying to take data from "OpenInvoices" tab and paste into "Invoices to Pay" tab, but only for the ones that have an x in column k on "OpenInvoices" tab. I am trying to attach a file that shows what I am trying to do (please let me know if it does not come through). I want to take the data in grey on OpenInvoices tab and make the grey section on Invoices to Pay tab. The length will vary everytime I run the button to make the selection. Any further info needed, please let me know. I really appreciate anyone who takes the time to respond.

Thanks again,
theglitch

F-53 Post Outgoing Payments.xlsm

Try the attached.

Thank you very much. I think this will do the job. Thanks again for the quick reply.