Home » Blogs » Nick's blog

XLA routines: EE_FilterAndMove

Nick's picture
Submitted by Nick on 31 January, 2015 - 09:04
Use EE_FilterAndMove to filter data, and move that data to a new sheet - depends on EE_FilterAndCopyToNewSheet and EE_FilterAndRemove 
Sub EE_FilterAndMove(rngTable As range, strHeading As String, strCriteria As String, strCopyToSheet As String)
'http://excelexperts.com/xla-routines-eeFilterAndMove    for updates on this sub routine

   Call EE_FilterAndCopyToNewSheet(rngTable, strHeading, strCriteria, strCopyToSheet)
   Call EE_FilterAndRemove(rngTable, strHeading, strCriteria)
End Sub
»