Thanks for the quick response but the column resizing did not work. I am wondering if it has anything to do with the first row having a merged cell. Anyway, I noticed an even more urgent issue with my logic in the second part of my question.
2) Each newly created worksheets (Algeria, Angola...) should be populated with a copy of the partially-filled information from the "Template" worksheet before being automatically populated with that country's pertinent information from the Data worksheet - (Data: B?:M?)
The first part in (2) is working smoothly however I messed up extracting data from column "B?" to "M?". It is taking "Algeria" data (B3:M3) and populating all the other countries with that data. I was hoping it would extract B4:M4 for Angola and populate Angola's worksheet with that information. Then it should work down the list using the next country with the relative range (B?:M?)
If this is not too much trouble I would appreciate any help you can render. I will continue to work with it but right now I can't seem to make any headway.