Our system currently captures data from the field using a mobile application. This data comes back into a core application and is available for export. Once exported the file is sent as a csv which could be from one row to hundreds of rows. There are over 20 columns and this data needs to be copied into a preset area on the second sheet of an excel workbook so that the first sheet can display that data in a unique format for the business. We have a team that normally does this but is busy doing application coding. We are seeking an expert excel, programmer with the ability to create a conversion for this assignment with the opportunity to upgrade to an FTP version moving forward. This round is predominantly a data manipulation requirement.
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do the data manipulation that you described.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$160 AUD 2 napon belül
4,7 (66 értékelés)
6,2
6,2
10 szabadúszó adott átlagosan $140 AUD összegű árajánlatot erre a munkára
Hi,
I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I can do this task for you. At my previous work my job was to create macros to manipulate and extract data from 10's of thousands of cells.
So lets discuss this project in detail and start at your earliest convenience. I can guarantee you the best possible work in least possible price.
Hello,
I am Excel and VBA expert.
I am very goot at data manipulation. I have done many similar projects.
I easily can complete this project.
Please note that I have 100% completion rate and 5-star feedback on projects.
I suggest to use a Pivot Table to do that! It is built-in Excel and it's the best approach since the Pivot Table code is way more precise than the VBA code I could write. What I can add though in VBA is a way to automate how the pivot table changes once something (button or event) happens.
Hello
More 20 years programming experience.
I need more details to set real price and time.
Regards.
---------------------------------------------------------------------------------------------------------------------------------------------------
I have extensive experience in Excel VBA and am fully capable of completing this project with the expected results within the turn around time. Please consider my application for this project. I have written many macros for data manipulation and am currently working as a technical support specialist.
Hello,
I have checked your requirement with both excel sheets and instructions in word document. I have good knowledge of excel and VBA scripts. I can do this job in 1 day.
Please consider this proposal and give me my first chance to show my skills.
Thanks and regards,
Rasika