For my project I need to organize information on the ecological footprint for 30 different countries which I randomly selected. All of the data for each country's biocapacity and ecological footprint from the years 1990-2013 is located on the excel workbook titled "EF and Biocapacity per country". I need help with transferring that information to the workbook titled "GDP PPP data" so that I may analyze it. I have already set up the framework, and I have already done a color-coded example of what I need done. I simply don’t have the time right now to sort it myself. Please do not change any formatting or do extra work that is not specified below.
Below are the detailed instructions:
In the workbook titled "EF and Biocapacity per country", there are thirty different tabs on the bottom (from "Ireland" to "Congo Dem. Rep."). As Ireland has already been partially completed, please look now at its corresponding tab.
Under the column titled “Record” you can distinguish if the data for ecological footprint ("EFConsPerCap"). Please copy the numerical data under the columns titled "Built-up Land", "Carbon", "Cropland", "Fishing Grounds", "Forest Products", "Grazing lands", and "Total" for each year for only ecological footprint and paste it into the document titled "GDP PPP data".
For example, in the tab “Ireland” in the workbook titled "EF and Biocapacity per Country", I copied the data ("built-up land" to "Total") for ecological footprint in the year 1990 (red). I then went to the workbook titled “GDP PPP Data” and pasted it to the corresponding year and country.
Please do this for each year, for all thirty countries within a day.
Thank you.
I love excel automation. I have seen your spreadsheet, and read your detailed instruction.. I can have everything re-organized as requested within a day.
ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
Hello, we are a team of qualified MIS experts if you are interested in getting work done by our team drop a message so that we can start working on it.
hola, tengo experiencia de mas de 10 años trabajando con excel, puedo ayudarte en lo que necesitas! soy rapido en dataentry. soy la persona indicada para este trabajo.
I am interested in doing the data sorting project for you. I am time conscious and have knowledge in excel.
Relevant Skills and Experience
Data entry, data analysis and data sorting skills.
expertise in excel has been my niche. Have done many work of this scale and hence confidently bidding and will be a very meticulous work that i can guarantee.