Question

Advanced Excel Filter Actio

  • 16 February 2024
  • 0 replies
  • 18 views

Userlevel 1
Badge +4

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? 

 


0 replies

Be the first to reply!

Reply