title: Excel VBA - Search Another Sheet On Cell Click
body: <p>I am looking for a way to get excel to search Sheet2 for the same text in the cell that was clicked on Sheet1.</p>
  
  <p>For example:
  Sheet2 contains names (column A), addresses (column B), and cities (column c), while Sheet1 holds a list of the same names (along with various other info). For simplicity's sake, all I need is to be able to click a name on Sheet1 and have it return the row number of the same name on Sheet2. Displaying the information in a  message box would work well enough.</p>
  
  <p>Any ideas on how I might be able to get this to work? I'm having trouble finding where to get started.</p>