Filter table inside Excel the fast way (using advanced filter) into another sheet.
This sub assumes all these sheets are presented in the same workbook.
ShSource, ShFilter and ShCopyTo.
Will have another version with more flexible options.
Used and worked perfect.

Make sure you understand AdvancedFilter in Excel to apply filter range, data range and copy to range. This sub uses Excel AdvancedFilter.

Trick to use ANmAdvancedFilter below
    To filter large table on multiple columns at the same time having each column to be one of many values
    Use .... multiple sheets to filter once per column
    Like we did in Reiporter tool



My Own Work

ShSource, RSource, ShFilter, RFilter, ShCopyTo, Optional RCopyTo = "A1", Optional WB = "This"

Views 1 Downloads 0