Hi, I have a workbook with many worksheets, each worksheet corresponding to a project, that is, a worksheet will have all the details related to one project. This workbook is basically a database which cannot be directly accessed by others.
So I have another workbook, called search which the user can access directly.
The user will enter some texts in search workbook, the code has to search all the worksheets in database workbook for the text and return the names of the projects having this text. The search result has to be displayed in search workbook, In no case database workbook should be opened.
Can someone help me in writitng a code for this?? Its eating my brain...
So I have another workbook, called search which the user can access directly.
The user will enter some texts in search workbook, the code has to search all the worksheets in database workbook for the text and return the names of the projects having this text. The search result has to be displayed in search workbook, In no case database workbook should be opened.
Can someone help me in writitng a code for this?? Its eating my brain...