I have tried using the advance filter unsuccessfully. the seven columns i
need to filter are not consecutive. any tips on filtering independant
columns?