Convert information in one tab of an excel spreadsheet to a static format in another tab in the same excel workbook.

$30-250 AUD

Terminado

Publicado

hace casi 9 años

$30-250 AUD

Pagado a la entrega

Our customers currently place orders with us on a form set up in JotForm. I want to be able to import those orders into our financial system - EXO. I can export the orders from JotForm in an excel spreadsheet (example attached). But to be able to import these orders directly into EXO I need the data re-arranged into a specific format in another tab in the same excel workbook. I would like a small application I can run whenever I open my JotForm excel report which grabs the data from the report, creates new column headings on a new tab and then transposes the data into the desired format. I have attached an excel spreadsheet - the first tab is the export of 3 orders from JotForm while the second tab is the required output.

Excel

ID del proyecto: 8081194

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@d2imatrix

Hi, I went through the details of jot-form to EXO system compatible input. We are expert in excel based data processing. We can do this job error free. We would write a VBA code in background. Once you put new data in "JOT Frorm Export" tab and click a button (which we would create and link the VBA) it would the desired output in "Required EXO Format" tab. Kindly let us know if you want to to get engaged in this. Regards, Pal

$45 AUD en 3 días

5,0

(16 comentarios)

4,6

6 freelancers están ofertando un promedio de $74 AUD por este trabajo

@deepbluetech

Hi, I am an Excel macro expert and would be happy to take on your project. My solution will be an Excel macro based file with an user interface to select the JotForm exported Excel file. The output sheet will be generated and the user will be prompted prior to saving the file. Shall deliver within a day on confirmation. Regards, Arul

$50 AUD en 1 día

5,0

(147 comentarios)

6,5

@binaryromel

A proposal has not yet been provided

$55 AUD en 1 día

4,8

(75 comentarios)

5,8

@kevivu

Having more than 11 years of experience in banking /finance /accounting, business analysis, Data analysis, process re-engineering, Bookkeeping, copy typing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes complex Formulae, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills.

$45 AUD en 3 días