To boil this down as best I can, I have 2 separate workbooks. I have copied the 2 columns of data from Workbook 2 into sheet 2 of Workbook 1. I used the search function in the best manner I could. No one seemed to have the specific issue I am having atm. It is very possible I searched for the wrong terms, so if a post does exist with my specific issue, please lmk.
What I have tried to do with the below Macro is the following:
- The value of Column A on Sheet 1 matches a value in Column G of sheet 2.
- On Sheet 2, the value of Column H that corresponds with the matching value found on Sheet 2 I want to be copied/pasted, inserted, linked, mirrored (etc.) into Column B of sheet 1.
I added a Do While loop into the macro to run down through the list until it reaches an empty row, but the problem I'm running into is the Find function needs an explicit value (i.e. "Sample"). I cannot seem to locate a proper replacement such as "ActiveSheet.Paste" to insert the copied date into the Find searchbox.
Am I going about this the wrong way? Should I scrap the code I've made for something completely different?
Please Login or Register to view this content.
Bookmarks