Good afternoon, doing an automation in VBA in which I need to loop through filters on different lines (sequential values from 1 to 95) but my selection will be with the filter criteria "other than".
Copy the excel tab to a new worksheet, select the value other than 1 and save it with the cell name B2, after that, I automatically close the worksheet, copy the same previous tab and this time filter the values other than 2 , I do the same process sequentially until I complete the number of repetitions.
I can not evolve in the autofilter selection loop, could anyone help me?