I have two excel sheets that I want to merge.
The data is a list of vocabulary that I’m learning, so it’s a constantly expanding list. Sheet 1 was downloaded earlier and contains fewer words; sheet 2 was downloaded later and includes all vocabulary in sheet 1. The problem is that I’ve made notes in the cell next to some, but not all of the words in sheet 1.
Basically I want to have the longer list of words (ie sheet 2 data), but keep the additional data from sheet 1
So sheet 1 (apologies, don’t know how to get formatting to show a table)
Column A…Column B
adiós…(blank)
abuelo…granddad
amigo…(blank)
… (250 words)
Sheet 2
Column A…Column B
adiós…(blank)
abuelo…(blank)
aeropuerto…(blank)
agua…(blank)
amigo…(blank)
I’ve tried the Edit > Track changes > Merge, but that does not seem to do what i want.
This will be an ongoing exercise as I occasionally download the vocab list to excel, so if there’s another way to set it up so that it doesn’t need merging, I’m happy to try before the list gets longer. The list that I download changes order on a daily basis, so I can’t just append to the bottom of sheet 1.
I can think of 3 possible approaches, but don’t have the skills to make any of them work: using vlookup; using find duplicates and deleting the row with a blank column B; comparing and merging but using info in column B to take priority in the merge.
Many thanks in advance.
torata