Build a Excel Worksheet with information in different formats in multiple sheets. Will involve manual typing of information.

Completed Posted 7 years ago Paid on delivery
Completed 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

Copy Typing Data Entry Excel

Project ID: #10715382

About the project

6 proposals Remote project Active 7 years ago

Awarded to:

Kalpanasekhar

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

$157 AUD in 2 days
(206 Reviews)
7.9

6 freelancers are bidding on average $157 for this job

zebracaro

I can do it for you quickly and exactly by vba

$250 AUD in 5 days
(114 Reviews)
7.0
beltran0404

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

$60 AUD in 5 days
(136 Reviews)
5.7
dcatt47

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

$100 AUD in 3 days
(2 Reviews)
1.6
ahmednawaz0011

Allow me to work this out?

$222 AUD in 5 days
(0 Reviews)
0.0