How am i suppose to use the advance excel filter command?  

First one challenge i see with the paramters of this command is than several selections are hardcoded and do not offer variable control.  But beyond that, i am successful af executing the filter but, i can not find a way to get at the filtered data and make the necessary data changes.

Best i can tell the filter action is for display only and offers no advanatage for obtaining or operating on the reduced data set.   Outside of saving the spreadsheet in filter format i cannot determine what is next?

even if the dataset was writeable to a datatable how could i use these fact to make the edits to the excel spreadsheet?