vba - Search through Excel tabs -

i not familiar vba programming, though have written few basic modules. having difficulty in coding following problem. appreciate if show basic solution. problem: have 3 tabs in excel file, "rack1", "rack2" , "rack3". each have column called "tag". tag column contains code, made of numerals 0 9999 , 1 letter, or b. want first "a" code in rack1, find matching "b" code. if b code not in tab "rack1", want search tab "rack2", "rack3" if it's not found in either. after "b" part found, want have msgbox message - "found in rack..." or "b part not found"

then ... go on next code. thanks

please let know have tried far things working @ end.

you may have loop through requirement sheets respective column , range.

i not clear, exact requirement can this

declare variables of sheets

set sheet1 = worksheets("sheet1")  set sheet2 = worksheets("sheet2") set sheet3 = worksheets("sheet3") 

you have set range per need. have loop sheet1 , tag column. while searching need check whether exist in respective cell cell value see below example

if instr(cell_value, "a") > 0 

meanwhile can check below post further reference.

excel looping through rows , copy cell values worksheet