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.
Advance Filter Macro: Copy To Another Sheet
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
Re: Advance Filter Macro: Copy To Another Sheet
=IF(N3>0,"▲",IF(N3<0,"▼","◄►")) how do u get that direction sign
Don’t have an account yet? Register yourself now and be a part of our community!