Excel Cleanup Macro

$75-350 USD

Completed

Posted

about 6 years ago

$75-350 USD

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.

Visual Basic for Apps

Project ID: 16335092

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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:

@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

4.9

(256 reviews)

6.5

10 freelancers are bidding on average $229 USD 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 assist you in getting this task done with more focus on quality and getting it delivered on time. Hoping to serve you in the best possible manner and completing it to your level of satisfaction. Looking forward to work for you. Hope to hear from you. Have a nice day. Regards, Nidhi

$236 USD in 10 days

4.8

(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 background in retail) and have a working knowledge of HTML (which may help when cleaning the data in your HTMLBody column into the required columns, though the spec was pretty clear on the requirements here). As well as expert level skills I have an eye for spotting patterns, and a creative approach to problem solving which mean I have often been able to work with data others have deemed unusable. I would love the opportunity to work with you on this project!

$333 USD in 4 days

5.0

(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 to beat your imagination. Let's work together to make it happen. Let me know if you are interested and we can always start from something small.

$236 USD in 10 days

5.0

(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 create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$83 USD in 3 days

4.9

(17 reviews)

3.6

@Carlosemadrizmor

A proposal has not yet been provided

$224 USD in 2 days

5.0

(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 enough to handle any kind of computer related job.

$236 USD in 10 days