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
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Views 188
Downloads 89
