Hi guys,
I hope someone can help me.
Been trawling through the forum but cant seem to find exactly what i'm looking for.
Basically i have 2 spreadsheets i am merging.
One (S1) is the main spreadsheet with details of Wills and the client who it belongs to and is updated daily.
The other (S2) is a smaller speadsheet which is just concentrated on finding wills and info that was not initially found.
The second spreadsheet is more up to date in relation to our 'missing' Wills and so have more info in my 'comments' column but the rest of the row info is the same.
When i merge the two (same column format etc) is there a way that i can delete the duplicates with older info (in S1) or replace that info with that from the newer spreadsheet (from S2)?
Or even just merge both sets of information?
Im not great on excel so a dummy's guide to this problem would be fantastic!!
Bookmarks