Find and paste value if found VBA help!

[Zomgz92]

Hi All,

Was wondering if anyone could help me with this.

Basically I would have two work books with changing names, but would consistently have the same format.
The unnique idetification number in both is in column A, and the values are in column E.

I would want to replace the values in column E in the second workbook, with the values of column E in first workbook. Normally, I would use Ctrl+F, and find and replace and manually do it.
I was wondering if there is a VBA which could do this for me.

One which goes through all the values in column A in first workbook, and if it matches the second work books column A, replace the Column E in second workbook with the column E in the first work book!

If any hep or direction could be provided would be amazing! .

 

[My Aswer Is This]

We always need specifics.
Are we really dealing with different Workbooks or different Worksheets?
You said:
Basically I would have two work books with changing names

And if the Workbook name is always changing that might be a difficult situation for me.
And if we are dealing with different worksheets can you provide the sheet named.

Please be specific and maybe I can help you

 

[Zomgz92]

We always need specifics.
Are we really dealing with different Workbooks or different Worksheets?
You said:
Basically I would have two work books with changing names

And if the Workbook name is always changing that might be a difficult situation for me.
And if we are dealing with different worksheets can you provide the sheet named.

Please be specific and maybe I can help you

Hi! Thank you for replying . Sorry for not being clear. There are two different workbooks . The Source workbook name and worksheet are variable, but destination will have the word "CAT" in it . Sheet name is vlookup !

If it is not possible to have variables, is there a way to have a prompt box pop up where you can define the name when you hit the vba ?

 

[My Aswer Is This]

Hi! Thank you for replying . Sorry for not being clear. There are two different workbooks . The Source workbook name and worksheet are variable, but destination will have the word "CAT" in it . Sheet name is vlookup !

If it is not possible to have variables, is there a way to have a prompt box pop up where you can define the name when you hit the vba ?

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.