After filtering a table, extract filtered data to another worksheet, erase and repeat

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

Hello again,
If this may help, this macro does similar things for what I'm looking to do: http://www.excelforum.com/excel-prog...19#post2827719

However, I don't need the filtered data to be copied to another workbook file - Just to another worksheet in the same workbook. It can be the same output sheet every time, so if the macro button is re-clicked on the criteria sheet, then the filtered (or newly filtered) data from the criteria sheet is recomputed and extracted there every time.

Any help is greatly appreciated. Not very good at building macros.

Thank you!

Matt has anyone answered your request privately with filtering to new sheets i have the same questions?

Hi Friends,

I have same problem.

I have table with fields - Name, designation, Salary etc.

I have to filter on designation and extract rest of the fields into another sheet.

Can you help me with the macro code relevant to this?

Thanks in advance

Hima