Excel Cleanup Macro

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Objective:

We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs.

Scope of Work:

We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following:

1. Browse for the CSV or workbook to transform

2. Run the Script

3. Save the transformed file into the same directory with a “-transformed” appendage to the file name

I have more detailed examples in a docx and sample csv file attached.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #16335092

About the project

10 proposals Remote project Active 6 years ago

Awarded to:

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

$300 USD in 2 days
(256 Reviews)
6.5

10 freelancers are bidding on average $229 for this job

Nidhijain123

Hello, i know macros.I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assi More

$236 USD in 10 days
(87 Reviews)
5.8
katiewells3

Hi! I am a business analyst with 15 years professional experience building automated data cleansing and processing solutions with Excel and VBA. I have worked extensively with Shopify data (as I have a strong backgroun More

$333 USD in 4 days
(19 Reviews)
4.7
langlangFan

To Whom It May Concern: I am an expert in Excel Macro development with 15+ years of experience and good track records. I am interested in your projects and I believe I can deliver rich features of the application More

$236 USD in 10 days
(3 Reviews)
4.3
huongth

Hi. Please send me a message then i can send you sample. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can c More

$83 USD in 3 days
(17 Reviews)
3.6
Carlosemadrizmor

A proposal has not yet been provided

$224 USD in 2 days
(3 Reviews)
3.1
astro124

​I have been working over Data Entry, Article Writing, Word press, Re-writing Text from images and many other projects since last five years. I worked in many private sectors to improve my skills. Now I become able eno More

$236 USD in 10 days
(0 Reviews)
0.0