Find cell value in another workbook and place date stamp in row

Hi there,

I am relatively new to VBA, and in particularly any form of scripting/programming so any help would be appreciated

I have two workbooks, one for active clients and one for all clients (past and present) that I am working with. What I am after is a macro that once I have I finished with a client, it will put a data stamp in my other workbook called "AllClients.xlsx",

I am trying to search for the value I have in one workbook in cell "D6" of my activesheet, which is a unique client identification number, and look for the same value in another workbook called AllClients.xlsx in Sheet "AllClients", in Column A, and insert the date in the correct row in column D



What I am getting is Run-time error '1004' Application-defined or object-defined error.



The code that I do have is as follows:

Please Login or Register  to view this content.

Any help would be greatly appreciated

Hi & Welcome. Try to add "file" reference (note original error disappears, but other appears)

Please Login or Register  to view this content.

Hi, cladinshadows,

I would not use path and Cell as variables due to the fact that they are VBA-Keywords. And I guess the line

Please Login or Register  to view this content.

will be the one to raise an error as Cells means all the cells within a worksheet (I guess you imagined that to be the found cell to refer to).

Please Login or Register  to view this content.

Ciao,
Holger

Hi, cladinshadows,

maybe try using

Please Login or Register  to view this content.

Are you sure you want to search in Formulas and not in Values?

Ciao,
Holger

Thanks HaHoBe,

Changing it to values worked like a charm!! I played around with the code and this is what I came up with and is working fine!!

Please Login or Register  to view this content.