Build a Excel Worksheet with information in different formats in multiple sheets. Will involve manual typing of information.
$30-250 AUD
Paid on delivery
The Brief:
To compile 1 list of all Companies that supplied product to each of the Clubs listed, across 2014, 2015, 2016.
A main spreadsheet is provided to be updated with information, as well as each of the company below sales reports for 2014, 2015, 2016 years
The Licensee/companies are:
Company B, 2014, 2015, 2016
Company C 2014, 2015, 2016
Company D 2014, 2015, 2016
There will be gaps, as we don’t have information from Company A.
The problem we have is that each club name is written/spelt differently in the sales reports provided by each company above to that in the main sheet/database. This means that most of this may need to be entered in manually.
If you are unsure of any of the line items, please highlight in yellow, and I can cross check upon completion and update.
There are 687 line items to be updated, by 2014, 2015 and 2016 years. Also, you will need to collate all total sales for each club for each year (687 lines). Not all figures will be provided in Company sales reports as a lump sum, so multiple lines may need to be added
Please see following for example
Project ID: #10715382
About the project
Awarded to:
Well, this work can be done by tomorrow. My price is $150. I did go through your requirement and understood the problem you are having with the sheets. I will set all things up and enter all the sales details ma More
6 freelancers are bidding on average $157 for this job
Hello, I hope you are ok. It will be my pleasure to help you in this. I'm excel developer and I also can do copytyping jobs. I will be accurate with your data and I can also make a sample of reports you need. I More
Greetings, I understand what you need done and would be more than willing to assist with it. Please feel free to contact me directly. Best Regards, David