Hi
I have searched everywhere for this and apoligise if it is on the board already. I would be grateful for any help.
I need to create a workbook that has a cell for users to enter a seven digit ID number. When the number is entered, Excel will search through Row B of multiple Excel files and folders (all closed) for that number. If the number is found, the sheet will then return the name of the file, the name of its folder and the data that lies in the cell adjacent the number in Row C (which is a client's name).
Thanks
Chris
I have searched everywhere for this and apoligise if it is on the board already. I would be grateful for any help.
I need to create a workbook that has a cell for users to enter a seven digit ID number. When the number is entered, Excel will search through Row B of multiple Excel files and folders (all closed) for that number. If the number is found, the sheet will then return the name of the file, the name of its folder and the data that lies in the cell adjacent the number in Row C (which is a client's name).
Thanks
Chris