Do some Excel Work
$10-30 USD
Paid on delivery
Please familiarize yourself with the attacked Excel Workbook, and message me with any questions you may have only after having done so. Example outputs will be useful for winning the bid.
The Sheet "Country List” contains a list of countries with their “birth” and “death” dates. These countries are found in the first column of the subsequent tabs. Annual data appears after the country column. Currently data (in 1’s and 2’s) has been entered.
I require a simple macro to update every sheet in a given workbook with zero's where there is missing data between a given date. More specifically, the following rules should be looped for all tabs:
1. If a country from "Country List" does not appear in the first column of the tab, add it
2. If a country is “dead” for a given year (i.e the current year is before its “birth” or after its “death”) then the country-year is left blank (null)
3. If a country is “alive” for a given year (identified in row 1 of each tab), and the year has data for any other country, each country must have data
4. If there is currently data for the given country-year, keep it as-is
5. If there is no data for the country-year, but both the country is alive, and the treaty has active participants, the country-year should receive a value of 0.
6. If a country is found that does not have a lookup value from the “Country List” sheet, it should appear in a summary output sheet.
Project ID: #6371593
About the project
18 freelancers are bidding on average $27 for this job
Hello ready to start asap to deliver you, checked your file, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, c More
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
Hi, expert here, ready to start, I assure you high quality work done, hoping for a positive reply, thanks & regards.
Hello, I read the project description. At point 1. , are you talking about first sheet after "Country list" ? I didn't understood this point. I looked over the excel file. Contact me, Kind regards, Dragos!
Hi, Experienced Data Entry Expert and VBA Programmer. Expertise in Data Entry, Data Processing, Excel and VBA. Read and understood your project description. I saw your attached file. I've completed VBA p More
I would be greatly pleased to join your project for the post of Copy Typing Freelancer as I posses the required skills and experience in this arena. I have many years of experience working as a Copy Typing Freelancer a More
i have been done this type of work so i can easly done this work in two days without errors in time.
Hello Dear, I am glad to have your proposal. Although I am new freelancer, ensure you to complete the job within dead line with 99% accuracy. Thanks Imran
Hi there, please find attached file. in second tab i have wrote zero where the box was empty. Is that the same work u want? Please specify. these points: 2. If a country is “dead” for a given year (i.e the curren More