VBA Copy row into new worksheet based on Control Form Check Box

Hello,

I am hoping someone might be able to help me with this issue. I have over 3,000 rows in a worksheet with data in each column from A8 to D3000. In column E, I have inserted a form control check box.

I need a macro that will find which rows are selected by the check box (keep in mind I have hidden rows with check boxes that may or may not be selected), and copy those selected rows to another worksheet named "Products Summary" and paste them in that tab beginning at A8.

Here is a similar code that I am using with a dropdown:

Please Login or Register  to view this content.

Any help is much appreciated.

Kind regards!

I found this code, but it does not work for me. Any advice?

Please Login or Register  to view this content.