Compare Sheets

[chrism_cfu]

Hi to all!
Once again I need your expert help.
I have a file with 4 sheets.
Sheet 1 is the master sheet.
I would like to have a vba that can search all 4 sheets and make highlight the values in sheet 1 column A.
I would like the search capability to search also not only the A column for all the sheets but also to the column b where in this field may have also text (with space between the value that I want to compare and text. See example in sheet3 column b. the value that I want to compare is F26CS300003070 and in with a text.) so I need a compare like that
Sheet1 column to Sheet 2 column A,B
Sheet1 column to Sheet 3 column A,B
Sheet1 column to Sheet 4 column A,B

Thanks a lot in advanced
Chris

example_cm.xlsx

[lancer102rus]

Well. Hope you need this.

example_cm.xlsm

[chrism_cfu]

what can i say Lancer102 for your quick reply...
but i cannot run the macro probably because the can read the letters (see attachment)


lancer.jpg

[lancer102rus]

just delete them and name as you wish. Then link this sub to the button

[chrism_cfu]

Lancer you are officialy my Hero!!!
thanks a lot... greetings form Greece my friend!!!

[lancer102rus]

chrism_cfu, you are always wellcome! :-)