I am working in excel 365 abd I am looking for either a formula or VBA code (if simple).
I have a sheet let's call it "merged data" where I want to gather information from "List 1" and "List 2".
In "List 2" I have duplicates, and I want to have the value of the most current data returned in "Merged data".
I do not want to alter "List 2" to remove duplicates because that sheet is the one i will keep dropping the information (copy/paste), so trying to do less manual steps each time i have new information.
Thanks in advance.
I have a sheet let's call it "merged data" where I want to gather information from "List 1" and "List 2".
In "List 2" I have duplicates, and I want to have the value of the most current data returned in "Merged data".
I do not want to alter "List 2" to remove duplicates because that sheet is the one i will keep dropping the information (copy/paste), so trying to do less manual steps each time i have new information.
Thanks in advance.