LevelThought
MIS
Task: Have a list of 900 unique account numbers that should appear in one of the 200 Microsoft Excel workbooks that are located on several network drives. Initially, I sorted the 900 account numbers and was opening up each workbook and searching for the account number! However, this is not feasible! Therefore, I downloaded a full-text search utility that scans within files on my local or network drive and looks for a given keyword, a number of keywords, or a phrase. This appears to work if I type in 1 account number at a time.
Question: Is anyone aware of a method or software that will allow me to enter a block of account numbers (For example, all 900 account numbers) via an Excel worksheet and then have the search utility to list the Excel workbook for each of the 900 account numbers in another column, etc.? In other words, I would like to enter the 900 account numbers all at once instead of one-at-a-time. (Also, the account number might appear in more than one Excel file.)
Thanks in advance.
Question: Is anyone aware of a method or software that will allow me to enter a block of account numbers (For example, all 900 account numbers) via an Excel worksheet and then have the search utility to list the Excel workbook for each of the 900 account numbers in another column, etc.? In other words, I would like to enter the 900 account numbers all at once instead of one-at-a-time. (Also, the account number might appear in more than one Excel file.)
Thanks in advance.