After setting a filter in excel, How to copy the results to new sheet?

[Clerythecleric]

First time using the excel UDF, I have managed to write a simple script that just simply applys 2 filters and then sorts them in order. I need to copy the results after the filter is set to a new sheet. I did manage to pull somthing together but that copied the entire document over and i just need the ones applied after the filter. Or alternatively just delete all the rows that are not picked up in the filter.

 

I tried messing with " _Excel_RangeCopyPaste " and _Excel_RangeDelete  but i just can't seem to get the hang of it. IF anyone could be kind enough to push me in the right direction I would really appreciate it!

 

Thanks

 

This is what i have so far, i know its basic but it does exactly what i needed it to.

#include <Excel.au3>
#include <Array.au3>

HotKeySet("{ESC}", "On_Exit")
HotKeySet("{F1}", "FilterSheet")
HotKeySet("{F2}", "test")

global $workbook = _Excel_BookAttach("Book1")
if @error Then
   MsgBox("", "Error", "Could not attach")
Else
   MsgBox("", "Attached", "Attached Successfully")
EndIf

while 1
   Sleep(50)
WEnd

func FilterSheet()
_Excel_FilterSet($workbook, Default, Default, 12, "<0")
_Excel_FilterSet($workbook, Default, Default, 4, ">1")
_Excel_RangeSort($workbook, Default, Default, "L:L", Default, Default, $xlYes)
EndFunc
    

func test()
$aResult = _Excel_RangeFind($workbook, "<1")

EndFunc

func On_Exit()
Exit
EndFunc

 

 

Edited August 4, 2017 by Clerythecleric

[water]

An example can be found in the wiki.