En cours

Upload Report Into Excel

I would like the attached "JE-Postal-Heat-Map" to be auto populated by uploading the attached report "postal-codes-raw".

In the report "JE-Postal-Heat-Map" you don't have to worry about populating Columns K to Q. Below is what I would like populated.

The postal codes in "JE-Postal-Heat-Map" should be matched up with the postal codes in "postal-codes-raw" and the information that I am looking to populate is ;

- Total Dr's (restaurants) in each postal code

- How many of the top 8 cuisines are located in each postal code

In the "postal-codes-raw" report there are no cuisine headers like there are in "JE-Postal-Heat-Map". There is just cuisines Id's in the report. Below is each ID matched up with the correct cuisine I would like to show;

27 - Italian

28 - Greek

30 - Thai

31 - Indian

33 - Chinese

35 - Japanese

51 - Middle Eastern

64 - Pizza

In the "JE-Postal-Heat-Map" file there are also tabs broken down by which postal codes are in each region. I would like these populated as well. If we could have 1 upload form that would do all the populating, that would be ideal!

Let me know if you have any questions!

Thanks!

Compétences : Excel, Visual Basic

Voir plus : s thai, upload form, japanese italian, into italian, excel report, cuisine, auto uploading, heat map excel, japanese form, italian japanese, heat map code, middle eastern, codes excel, report information, thai chinese, file excel restaurants, thai japanese, excel greek, italian pizza, populating , map tabs, excel upload, greek italian, italian excel, auto form excel

Concernant l'employeur :
( 44 commentaires ) Toronto, Canada

N° du projet : #2400675

Décerné à :

ZeusMan

Hired by the Employer

60 $ USD en 3 jours
(82 Commentaires)
6.0