Export Data into another sheet
 

I need help with two questions. Please!

1. After appling a filter with a command box (already have this built). I
need to export the records left after filtering to another workbook I have a
macro on. The amount of records left after filter will change each time. I
also need it to only take certain columns of the data; not all columns.
Please help with the code.

2. How can based on a command button turn some columns off and turn some
back on.