我是否要使用VBA检查特定列中的所有行是否包含Excel中的特定字符串?

I have 2 columns of data in different sheets. We could call them A and B.B has a lot more rows of data than A and the data is also not the same. To be specific, in each data field there are some extra text appended at the end or in the beginning in B from A. I am trying to find out all possible rows in B which contain each row in AI have 2 columns of data in different sheets. W