Sets Autofilter in a sheet, and another function to clear Autofilter
FilterSheet_1By1 will set filter in a sheet for a certain table in a sheet.
Table means any list of cells (columns and rows) that identified by having no break
You can set the cell where that filter to be created (any cell within that Table)
This one will filter table by 1 value in 1 column
We are planning to have in future a filter by more than 1 value in more than 1 column.
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 LoginFilterByValue, Optional FilterColumn = "B", Optional Wb = "This", Optional Shee = "This", Optional FilterA1 = "A1"
Or
Optional Wb = "This", Optional Shee = "This"
Or
Optional Wb = "This", Optional Shee = "This"
Views 1,368
Downloads 465
CodeID
DB ID