Hi folks:

I'm looking for some code help in Excel VBA that search a single value from user input, for example input the number: "202550". Then it will search this number from the multiple workbook, for example: 012013.xls, 022013.xls, 032013.xls etc. Those workbooks only contain 1 default worksheet called Sheet1.

If it search the value, just put today days beside the value, else just let the user know the value is not existed.

For me, I can only did something that can only search in 1 workbook. If the value doesn't exist. I have to jump to another one and run the macro again and search.

Has anyone tried something similar? If so, would you like to share your ideas? Thank you very much.