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

Completed Posted Jul 16, 2015 Paid on delivery

$30-250 AUD

Paid on delivery

Completed Paid on delivery

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

Project ID: #8081194

About the project

6 proposals Remote project Active Jul 16, 2015

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Awarded to:

d2imatrix's Profile Picture
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 More

$45 AUD in 3 days
(16 Reviews)
4.6

6 freelancers are bidding on average $74 for this job

deepbluetech's Profile Picture
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 ge More

$50 AUD in 1 day
(147 Reviews)
6.5
binaryromel's Profile Picture
binaryromel

A proposal has not yet been provided

$55 AUD in 1 day
(75 Reviews)
5.8
kevivu's Profile Picture
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. More

$45 AUD in 3 days
(19 Reviews)
4.3
aneshkvyaas's Profile Picture
aneshkvyaas

A proposal has not yet been provided

$100 AUD in 3 days
(0 Reviews)
0.0
Post a project like this