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?