I have two lists with identical headers.
Stock Price Yield
the first list is my master list of information.
The second list is new entries.
I want to be able to combine the two lists, but only have one line for each stock... if there is a stock that shows up in the master list AND the new list, the values (for price & yield) in the new list should take precedence.
I'm not sure where to start on this one... if it's a matter of writing a macro, or some type of advanced data filter, but I'm pretty sure it can be done.
Thanks in advance!