Convert information in one tab of an excel spreadsheet to a static format in another tab in the same excel workbook.
$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.
Nº del proyecto: #8081194
Sobre el proyecto
6 freelancers están ofertando un promedio de $74 por este trabajo
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 Más