Combine data from Zoho CRM into a single excel spreadsheet

$30-250 USD

Ukończony

Opublikowano

około 10 lat temu

$30-250 USD

Płatne przy odbiorze

I have downloaded our data from zoho crm. Since the application uses interlocking databases, our data is in 14 spreadsheets. I need an expert to combine this data into a single spreadsheet with all the data on the single spreadsheet. There are about 10,000 contacts from about 3,000 companies with notes, potentials, and other information that must be on the single spreadsheet. No two spreadsheets have the same data or can even be linked. It will require linking a third to identify the common areas. I have done this in the past with Access, but I don't have time to do it now. If you are an Access expert, it will not take long. Thank you for your interest.

Excel

Microsoft Access

Identyfikator projektu: 5432518

Informację o projekcie

7 ofert

Zdalny projekt

Aktywny 10 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@chriskerpini

Hello, I can certainly combine these worksheets into one. I will use Excel functions and/or VBA code, if this will make things faster and more efficient. I have done a similar merge before, with fewer spreadsheets coming from Zoho crm. I will need max 2 days. I could also write VBA code for the merge, which could be used in the future, given that spreadsheets will keep the same format (same columns headings and same columns number). A few words about me: I'm developing VBA macros for more than 1 years and I'm trainer for both Excel and VBA (all levels) for 12+ years. As you can guess, I have done many times similar projects, I have written a plethora of macros of any kind and difficulty level. Looking forward to hear from you, Kind regards, chriskerpini

$90 USD w 2 dni

5,0

(13 opinii)

4,5

7 freelancerzy składają oferty o średniej wysokości $128 USD dla tej pracy

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

$111 USD w 3 dni

5,0

(29 opinii)

5,0

@BrothersTeam

Hello I am able and ready to start the job right now. I have done lots of similar jobs with accuracy. Thanks

$155 USD w 3 dni

5,0

(12 opinii)

4,3

@nswapsj

Hi there, As an experienced Data Analyst I am well versed with projects like these. In your instance I am thinking of running your raw data through my own analysis tools (probably SPSS or Microsoft-BI). Usually this helps in obtaining much better result. In addition it allows me to run complex exception reports in order to obtain optimal result. >>>Do you have a comment key between the to sets? Drop me a line for further chat. Regards, Ed

$155 USD w 3 dni

0,0

(0 opinii)

0,0

@EdliraM

Spreadsheets and access are my strong point. Ii have been using them while making industry analysis and market analysis, entering and processing very large amounts of data. If you award me the project, you will not regret it. Due to the quality of my work, I'm sure you will come back again. Let's discuss details and let's get started.

$144 USD w 3 dni