Search notes:
Excel: Data -> Sort & Filter -> Advanced
Actions
There are two action possibilities:
Filter the list, in place
Copy to another place
These two actions correspond to the two values of the
xlFilterAction
enumeration:
xlFilterCopy
xlFilterInPlace
VBA
The functionality of advanced sort & filter is exposed through a
range's
advancedFilter
method.
See also
The
worksheet function
Filter
offers a similar functionality.
Index