title: Search through Excel tabs
body: <p>I am not very familiar with VBA programming, though I have written a few basic modules. I am having some difficulty in coding the following problem. I would appreciate if someone could show a basic solution.
     Problem: I have 3 tabs in an Excel file, "Rack1", "Rack2" and "Rack3". They each have a column called "tag". The tag column contains a code, made up of numerals 0 to 9999 and one letter, A or B.
      I want to look up the first "A" code in Rack1, then find the matching "B" code. If the B code is not in tab "Rack1", I want to search tab "Rack2", then "Rack3" if it's not found in either.
    After the "B" part is found, I want to have a Msgbox message - "Found in Rack..."  OR  "B part not found"</p>
  
  <p>Then ... go on to the next A code. Thanks</p>