I have a sheet that holds all the Data in 28 columns "DataSheet", I have the Criteria on another Sheet where I want the results "ResultSheet"
I want to exclude the Projects starting with A, the area starting with Y or R and the Team starting with U or P and leave everything else. So conclude Projects or area or area or team or team
The Criteria which is named as "Criteria" used is
filter.png
The code is
All it does though is copy across the whole DataSheet, it works with only one criteria in any column, and is picking up the Criteria on all rows that have content. Tried putting them all on the same row and it didn't work (gave no results), tried doing it manually and it didn't work. Putting the data as Projects (row 4), Area (both on row 5), team (both on row 6) doesn't work.
Really stuck. Any help gratefully received, thanks in advance.
Bookmarks