Enter Date in cell next to another with specific value

[AdamShack]

I have sheet with data in Cells C2 to E14.
If anything is changed in Col E, I have VBA code that will input today's date into a cell (C10), which happens to be next to a cell with entry of Report Date.

Please Login or Register  to view this content.

What I want to do is change the code to add Now() next to the cell with value/entry of Report Date instead of specifying Cells(10,3)
The cell with entry of Report Date happens to be B10. But in another sheet, that same entry may be B13.

How would I do this? What would that code look like?

Thanks for any assistance given.

[DonkeyOte]

Whether you should be referring to entire columns in your code is debatable, however, you might consider something along the lines of:

Please Login or Register  to view this content.

The Resume Next is not ideal should you wish to trap lack of "Report Date" field.

[AdamShack]

That works! I have tried this in a couple of different files where the Report Date value is in a different cell and all looks good.

If I may ask, how would i change the Target Column = 5 part to only show a range of cells instead of the whole column?

[DonkeyOte]

Generally speaking best to test Intersect of Target and Range of Interest, e.g:

Please Login or Register  to view this content.

Rather than test column number of Target.

[AdamShack]

So now the code looks like this:

Please Login or Register  to view this content.

But now the date does not show up.
What did I do wrong?

[DonkeyOte]

Did you change a cell within specified range ?

[AdamShack]

Upon further investigation, I was somehow working on a different sheet within the same file. This sheet did not have the code changes you gave me. Sorry.

Your solution ABSOLUTELY solves my problem, and I thank you so very much.

Now I just need to add this code to approx 384 different .xlsm files. If you have any clues how I can do this without opening each file and pasting code into each one, that would be awesome!

Thank you DonkeyOte!

[DonkeyOte]

Adding code with code is possible but not necessarily trivial, see:

http://www.cpearson.com/Excel/vbe.aspx

For you to decide if you want to go down this route...

[AdamShack]

Thank you for the hint AND for the help! Probably way to complex for me, so will just have to go the route of manually opening, pasting, saving and closing them all. That would probably be faster!
Now to figure out how to mark this thread as SOLVED, and give you credit!