使用嵌套的Ifs在数组中循环更快

I have an array of data on one worksheet. I need to loop through the array, evaluate each row based on certain criteria, and then take the criteria matched rows and copy them over to another worksheet. I wrote the following code to do this process. I have an array of data on one worksheet. I nee