Hi,
I have a data base that contains billing information and notes for each work ORDER inside an excel file. The billing section has some SIMPLE formulas to calculate costs and then I have a simple section that deals with notes dealing with that project. Each worksheet contains information on that project. The problem is that I have run out of room in that particular file. I can't add any more pages so now I have to start a new file. If I need to do a keyword search to find a project I have to now start doing the search on more than one file. I want to be able to search all the worksheets in all the files. How can I do it? I don't want to start an Access database. THANKS

billWhen you LAUNCH Excel and then click on the Open icon, the Open dialog PANEL shows a button called Tools to the top right. Click on it, select Search, and enter your search criteria. Will that work for you? Thanks man. It worked. I wish it worked better. When you are inside a workbook and do a search on a cell the list remains up as it goes from cell to cell no matter which page it is on. This takes a little more time to find the right file you are looking for, but it does work.