1. I need a macro that compares the cells in the column called "Name" for the two workbooks. If the names match, values from the respective columns named INFO 3, INFO 4, INFO 5 and INFO 6, must be copied from "TestB" to "TestA" in their respective places.
2. Notice that there are more columns named INFO3, INFO 4 etc. So i guess the code should not copy and paste the values based on the name of the columns, but rather their place in the workbook. It should then be considered that all the "INFO-columns" in "Test A" are shifted with 1 column, as it has the extra column "TAX" at column B.
3. Some names are duplicates. Both for workbook "TestB" and "TestA". It doesnt really matter if the code puts wrong values in those or skips them, as Ill put in the values manually for those.
4. Keep in mind that there are more than one sheet. The information is located in "Sheet1" for both workbooks.
Thank you so much in advance!
Alex
Bookmarks