Completed

Excel Cleanup Macro

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel name cleanup macro, excel format cleanup macro, excel 2007 macro convert csv xml data import, excel vba trim entire worksheet, vba clean function, excel clear contents on multiple sheets, macro to clean up data in excel, excel vba trim all cells in range, excel vba remove non printable characters, excel vba trim function, excel vba remove spaces from column, data entry, data processing, excel, visual basic, visual basic for apps, import multiple csv files excel folder macro, excel file cleanup macro, create excel macro check active directory account status, excel mkdir macro directory files

About the Employer:
( 66 reviews ) Richmond, United States

Project ID: #16335092

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
$230 USD in 1 day
(10 Reviews)
4.0
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
$236 USD in 10 days
(2 Reviews)
2.8
$180 USD in 15 days
(1 Review)
0.4
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