Hello, hope someone can help. Workbook 1 will have a file name in A1 (eg 12345PD) and a number in A2 (eg 123456789). When the macro is run (worksheet change) I need it to open workbook 12345PD.xls search in that workbook for 12356789, when it is found enter the current date into the cell to the right of the found value, save file 12345PD and close. Workbook 1 then needs to reset (ie A1 and A2 now blank) ready for a new file name and number.

I already have a macro that does something very similar within a workbook by searching all other sheets for values in an array and adding offset values when array values are found. And I also have a small macro that opens a workbook when entered into A1. I was hoping to try and take bits from them to create what I need, but as I didnt write them and my vba is not that strong Its been very unsuccessful!
The macros I have are:
Please Login or Register  to view this content.
and:
Please Login or Register  to view this content.
Please Help!