I am kinda new to VBA and have been using VBA to increase my efficiency and to analyze data faster so my VBA coding skills are not so great. This particular problem has me a bit lost as I have tried googling to get some code that I can modify but can't seem to find anything that does what I need.
Everyday I paste new data from a source report onto my sheet and then run code to remove duplicates based on a time stamp. So when I paste the data I have duplicate loan numbers but with updated information. However column "T" is the referral source which is a field that is NOT on my source data so when I paste the data and run the remove duplicates code I lose the referral source information because it is on the older record that gets deleted as a duplicate.
So I need code that will first search to see if the loan number exists in the old data (on the same sheet as in the example below) and if it has data in column "T" I want it to copy it to the new row.
In the example below the first record and 2nd record both have the same loan number but the 2nd record has "Joe Realtor" in column "T".
What code can I run to search every duplicate loan number and copy the value of column "T" to the record with the matching loan number that does not have a value in column "T"?
Everyday I paste new data from a source report onto my sheet and then run code to remove duplicates based on a time stamp. So when I paste the data I have duplicate loan numbers but with updated information. However column "T" is the referral source which is a field that is NOT on my source data so when I paste the data and run the remove duplicates code I lose the referral source information because it is on the older record that gets deleted as a duplicate.
So I need code that will first search to see if the loan number exists in the old data (on the same sheet as in the example below) and if it has data in column "T" I want it to copy it to the new row.
In the example below the first record and 2nd record both have the same loan number but the 2nd record has "Joe Realtor" in column "T".
What code can I run to search every duplicate loan number and copy the value of column "T" to the record with the matching loan number that does not have a value in column "T"?