I am so stuck guys.
I have two lists.
List number 1: Two columns, each column has random numbers and letters, but each entry of the column is paired up with other column.
Example list number 1:
Column 1 Column 2
291238 asdasda
2312 578ddassa
List number 2: Five columns, the absolute same thing, except one of the columns is EMPTY and in one of the five columns are SOME same records from column 1 in list one.
I am supposed to write a macro that would find what identical entries are in column in sheet 2 and sheet 1 and then copy the other paired entry from list number one to empty list number two.
Example list number 2:
Column 1 Column 2 Column 3 Column 4 Column 5
8795465 empty asdkj 897989 asdjooads
2312 empty 458945 sadds 4654564654
I need to get "578ddassa" from list 1 column 2 to list 2 column 2. The thing is that in list number two column one are SOME identical numbers that are also in list numeber one, some are not. So this macro needs to find which numbers are same in column 1 in both lists, then copy the paired entry from column 2 list number 1 to list 2 column 2 of the identical entry of list 2 column 1.
Oh. My. God.
Bookmarks