MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
With rgFilter .AutoFilter .AutoFilter Field:=7, Criteria1:="SPCLMDL" .AutoFilter Field:=10, Criteria1:=Array( _ "CRTD", "PCNF LKD REL", "PCNF REL", "REL"), Operator:=xlFilterValues .AutoFilter Field:=20, Criteria1:="<=" & Date, Operator:=xlAnd 'Late including today .Sort Key1:=Range("T1"), Order1:=xlAscending, Header:=xlGuess, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod:=xlPinYin 'Need to filter by not-equal to REJ in column 31, if the value REJ is anywhere in any cell in this column 'Sample data is CNF REJ PCNF REL could be in any cell. End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|drag and drop (but keep all) lines||11||48|
|Copy one row (from Word) into one cell||14||49|
|Formula will not allow me to add additional rows and still function properly||6||16|
|need to query data with cero||6||10|
Join the community of 500,000 technology professionals and ask your questions.