Macro to find and update information across multiple sheets and multiple workbooks

Hello,

I have developed a macro that aggregates information from multiple workbooks and compiles the data I am looking for into one workbook on one sheet.

I now want to take that data and find it in a worksheet(there are multiple ones) in a workbook that I specify and update that information. Is there a way to do this?

For example: If the macro ran and my worksheet now had Cell A6=Dog and A7=Golden Retriever, I want it to search worksheets in a specified workbook for Dog then replace whatever was in the next cell with Golden Retriever.

Thank you in advance.

Does this help?

Please Login or Register  to view this content.

Or this?

Please Login or Register  to view this content.

John Davis, thank you. We are fairly close here.

To help make it a little clearer (and this is the best I can do) I want the code to take whatever it finds in Column B of WORKSHEET A and search all of Column C in WORKSHEET for a match. IF a match is found I want it to update the data in column F of WORKSHEET B.

Hope this helps a little, thank you very much for working with me here.

Originally Posted by maxhecht2

John Davis, thank you. We are fairly close here.

To help make it a little clearer (and this is the best I can do) I want the code to take whatever it finds in Column B of WORKSHEET A and search all of Column C in WORKSHEET for a match. IF a match is found I want it to update the data in column F of WORKSHEET B.

Hope this helps a little, thank you very much for working with me here.

What would go in Column F?

Originally Posted by JOHN H. DAVIS

What would go in Column F?

So if an entry in Column B of the WORKSHEET A matches an entry in Column C of Worksheet B take data from Column C of WORKSHEET A and replace put it into that row in Column F of WORKSHEET B

Thanks!

Maybe:

Please Login or Register  to view this content.