Replace msaccess in finding

[gsrikanth]

As in MSACCESS it will find multiple search word in the column

using macro can we search multiple word in the sheet2 from sheet1 particular column

Please suggest

in sheet1 data
A
A
A
A
A
A
B
B
B
B
B
C
C
C
C
C

in sheet2 data C,D
after running macro
in Sheet1 on visible "C" Data rows only

thank u

[JohnTopley]

Please yellow banner on how to attach a sample workbook with truly representative data and ensure you have added examples of expected output.

[gsrikanth]

Only Adjust with Excel our policy due to budget. can help in this regards thank you please find the attachment

[jindon]

Try

Please Login or Register  to view this content.

[gsrikanth]

Thank you sir, Done