Your code already do the work , while what I meant by definite range is
actually where I copy just a single range one by one from
Range(cells(89,I),Cells(105,I) to C114 ,then make a comparison with D114
, from here anything that meet the criteria in K125 will be copy to D132
So copying the range to D114 , and if meet the criteria in K125 is done
,
is there a way also that a definite range can be automated too ?
It should work like : every range (89,i)to(105,i) will be compared to
all range before starting with another.