I'm working with Excel 2003.
I currently have two seperate spreadsheets of country data that I would like to combine. They both have numerical country codes as well as country abbreviations in a column, and these country codes and abbreviations are the same for both excel files. They also both have year columns that are the same format. I would like to combine the two spreadsheets but match up the data from one into the appropriate rows of the other. The other caveat is that there is a limited number of countries from the data sheet i want to combine the other data into so I only need a portion of the data.
Any help would be appreciated
Bookmarks