I am combining 6 different spreadsheets beside contact information from 6 different sources. Some of the headers are matching first name (1 spreadsheet have with the sole purpose 8 columns and another may hold 12 columns, more data) and much of the data inside these spreadsheets is adjectives. How can I combine adjectives of my spreadsheets, include the spanking new columns of notes and remove the duplicate library? Manually is not an route. The contact documents are over 6000 contact history respectively.
Answers: Is nearby a adjectives column that is to say one and the same through adjectives the spreadsheets? If so check out the Vlookup formula.
Say if you enjoy two spreadsheets that both enjoy a column for "end name" consequently you could use the vlookpu formula to introduction background from one spreadsheet to the other.
You might look into bringing adjectives eight spreadsheets into one acess database
I would regard that you would hold to sort them first. Then, the lone process I know to do it is to look at respectively row and delete the ones that are impossible to tell apart.
Good luck and I'll be watching for someone that know more that we do.