根据标准，从一个工作表复制到另一个工作表

I want to copy a range of cells to another worksheet based on the criterion given in column N. So for each row it has to check whether or not it meets criterion in column N. If the value in Column N = I want to copy a range of cells to another work