Copy the entire column if one criteria match within two data column

excel
activities

#1

Hi there,

Is there any way we can copy the entire row into new sheet after we match some criteria data?
For example
1 (first row)
the “I” column compare to this one
2 (second row)
also the same “I” column
if the data in i column match then we can copy the entire row for the first row and the second row we compare into the new sheet (the first row(example) to sheet2 and the second row(example) to sheet3)

is it possible to do this? :slightly_smiling_face:

Thanks and i hope you can understand my question

Regards

Himawan