Build a search tool in excel

  • Thread starter Thread starter Obi-Wan Kenobi
  • Start date Start date
O

Obi-Wan Kenobi

Is there any way I can build a search tool in excel so that I ca
retrieve data from another sheet. i.e. the search tool is built i
sheet1 and it can filter and retrieve data from sheet2.


Also is there a way of setting excel so that regardless of what sheet
may save the document it ALWAYS opens on sheet1.

Please advice
 
Back
Top