Master button to filter all records in ONE worksheet and export to new workbook

Hi there,

I have two worksheets in a workbook, and what I would like to do is:

1) select a specific quarter
2) hit a button
3) have excel filter all tables based on my quarter selection and output recordset to new workbook with the same property. (filter recordset should be locked down thus preventing users from modifying the record)

Please see the attached for the file.

In "Master" worksheet, there is a button and quarter selection.

Could anyone help me how to get started on this?

Thank you

Use Advanced Filter to copy to a temporary location on your worksheet and then copy the results to a new workbook.