Hello,

I'm looking for a macro (with a button) to extract filtered data (from criteria sheet) to another worksheet (output sheet). Also, if the data on the criteria sheet is then re-filtered and the macro button is then re-clicked, the output sheet's data will delete and then recompute with the newly filtered data from the criteria sheet.

I have these column headers and sample data rows on my "criteria sheet":

Property Portfolio Company City
Prop1 Port1 Comp1 City1
Prop2 Port1 Comp1 City2
Prop3 Port2 Comp1 City3

I have a hundred or so rows of data on my "criteria sheet". So the process would be essentially two-fold for the user:
1) Filter the data using Excel's standard filtering function on the criteria sheet (meaning I could filter first by Portfolio for example, and then select only certain properties in that portfolio and filter those).
2) Once the data is filtered as desired, the user clicks a macro button to extract only the filtered data to a similar table on another worksheet.

Another key would be as described above--if the user decides to re-filter the data and then re-clicks the macro button, the data on the output sheet will automatically delete and recompute with the latest/newest filtered data on the criteria sheet.

If someone can provide a macro for this process I would be much obliged!!

Thank you very much in advance.

Matt