Devoted to hardware, software, IT issues, and information technology management

I often get mixed up when it comes to searching formulas or values, whole or part cells. It's not an easy thing since I had used it in lieu of MS Project last time when I was handling a simple IT rollout.

Here is a free software - Advanced Microsoft Excel Find Function and a good starting point for more advanced searching of Microsoft excels if necessary. If you are using Microsoft Excel as a database, chances are you have noticed that the find function doesn't work very well across multiple sheets. This simple spreadsheet contains a worksheet and 3 macros that will help to eliminate all such problems by searching a range of sheets that you specify as well as making the correct decision when it comes to search options.