I have numerous workbooks which I need to compile in the following way: In
each of them, column A is a country name, and the further columns list
different stats about each country. I need all these workbooks to line up in
one page, however, the countries in each page are not identitcal, though
there is a lot of overlap.
For this reason, I cannot simply cut and paste the data responses to each
list.
Is there any way to tell the computer to do this, or do I need to go through
and do it by hand??
Please help!!