How to Select and Copy/Paste Columns Based on Checkbox

Hi,

I have a macro that takes an Excel table and copies it into a blank workbook as values. What I need to do is have it only copy columns that have a check box checked. My VBA knowledge is extremely limited (but I'm working on it!), so any help would be greatly appreciated. Below is my existing macro. It was made primarily from recording a macro.

Please Login or Register  to view this content.

My plan is to have check boxes above each table column on row 4 (my table starts on row 5).

Thanks for your help!

It doesn't need to be a check box. It could be a simple yes/no if that makes it any easier. Thanks!