Ukończone

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.

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel, Visual Basic, Visual Basic for Apps

Zobacz więcej: 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, excel name cleanup macro, excel format cleanup macro, excel 2007 macro convert csv xml data import, import multiple csv files excel folder macro, excel file cleanup macro, create excel macro check active directory account status, excel mkdir macro directory files

O pracodawcy:
( 66 ocen ) Richmond, United States

Numer ID Projektu: #16335092

Przyznany użytkownikowi:

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 w ciągu 2 dni
(256 ocen)
6.5

10 freelancerów złożyło ofertę na kwotę $229 do tego projektu

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 Więcej

$236 USD w ciągu 10 dni
(87 Oceny)
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 Więcej

$333 USD w ciągu 4 dni
(19 Oceny)
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 Więcej

$236 USD w ciągu 10 dni
(3 Oceny)
4.3
$230 USD w ciągu 1 dnia
(10 Oceny)
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 Więcej

$83 USD w ciągu 3 dni
(17 Oceny)
3.6
Carlosemadrizmor

A proposal has not yet been provided

$224 USD w ciągu 2 dni
(3 Oceny)
3.1
$236 USD w ciągu 10 dni
(2 Oceny)
2.8
$180 USD w ciągu 15 dni
(1 Ocena)
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 Więcej

$236 USD w ciągu 10 dni
(0 Oceny)
0.0