Paste from one workbook into the Find function of another workbook

[zombiemaster]

Hi, All...

Just looking to streamline a tedious process where I copy from cell A2 in workbook "mine" and paste it into the Cntrl-F FIND function in workbook "yours", find that data, enter today's date into column D and my initials in column E, then repeat for the next item down in column A in "mine". I know that sounds confusing so here is the step-by-step:

Activate book Mine
Copy A2
Activate book Yours
Cntrl-F
Paste into the FIND box and press enter (this is the part I can't figure out how to do)
Type today's date into column D
Type my initials into column E
Close the FIND box (if necessary?)
Activate book Mine
Move down one cell to A3
Repeat above steps

I have a couple hundred of these that I do each day, and am looking for some automation. I tried doing it myself but can't find out how to paste into the FIND box using VBA

Thanks in advance for any help!
~ZM~

 

[zombiemaster]

Ok so I really am leaving work now, but if you're still around, the code isn't working as expected - I put some 'real' data into Mine that the macro should have picked up, PLUS I also added the word "test" at the bottom of both workbooks and ran the code - the date and initials showed up just once, in the row I put "test" into. The other 'real' rows didn't do anything.

If we can't get this to work, it's not a huge deal but I do appreciate the help!

~ZM~

 

[Fluff]

What sort of values do you have in col A?

 

[zombiemaster]

They are 9-character alpha-numeric such as "ABC123456" formatted as General.

~ZM~

 

[Fluff]

Double check that your values are exactly the same and don't have any leading/trailing spaces.

 

[zombiemaster]

Double check that your values are exactly the same and don't have any leading/trailing spaces.

Sorry for the VERY long delay in responding - I got pulled off that project shortly after asking for help - they're going to be running automation through another process so my VBA is no longer needed. Thanks for trying to help, though, I do appreciate it!

~ZM~

 

[Fluff]

You're welcome & thanks for the feedback.