I am needing code that searches for "code 1" in a list on sheet one and if it
does not find it goes to sheet 2 and looks for "code 1" in a list and so on
until it finds "code 1" in a list in one of the sheets. Please help!