Advance Filter Macro: Copy To Another Sheet

zviju · Nov 23rd 2006

I Have a data sheet (Summary - All Teams) which will finally be a hidden sheet, and I want to filter the output of this sheet in another sheet (Sector_Summary) by selecting the options in the dropdown list box at N1 cell in Sector_Summary sheet (on selecting a option in the dropdown list a result is reflected in P5 cell). Finally what is required is that on selecting a option (eg. Banks) it's filtered result will be shown in the Sector_Summary sheet (C5 cell) and when another option is selected (eg. Autos) in dropdown list previoes result is erased and new output is shown.

Dave Hawley · Nov 24th 2006

Re: Advance Filter Result In Another Sheet By A Macro

Here is an example of AdvancedFilter in code that copies results to another worksheet.

Code

Sub AdvancedFilterToOtherSheet()
    Sheet2.UsedRange.Clear
    Range("Table").AdvancedFilter xlFilterCopy, Range("Criteria"), Sheet2.Range("A1")
End Sub

Where Table is a [dr]*[/dr] covering the table of data and Criteria is another one housing the needed criteria and table headings. Sheet2 is a Sheet CodeName. Note the UsedRange of Sheet2 is cleared BEFORE the filter.

To work with UserForms. Comboboxes and listbox see
Filter ListBox Data to Meet a Specified Criteria

odogwunwoke · Jun 20th 2012

Re: Advance Filter Macro: Copy To Another Sheet

=IF(N3>0,"▲",IF(N3<0,"▼","◄►")) how do u get that direction sign

Advance Filter Macro: Copy To Another Sheet

Participate now!

Share