Find Jobs
Hire Freelancers

Large Excel Spreadsheet Modification (VBA macros needed)

$10-30 USD

Finalizat
Data postării: peste 6 ani în urmă

$10-30 USD

Plata la predare
I need an Excel expert who will transform my spreadsheet using macros. 1. Each unique product has 3-15 rows with data following the unique EAN. I need these rows to be transformed into columns. - So each unique product should have only 1 line with all of its data spread into different columns. 2. There is no specific amount of rows which follow the unique product - they differ per product type. 3. You have to be familiar with VBA macros. 4. I need the script's code for future running of the same spreadsheet with updated data. [login to view URL] Name - these should be name of the columns [login to view URL] Value - these should be the values of the cells under the corresponding column Name 7. Category column - should be Category1, Category2, Category3 and each value under the corresponding column. 6. If you want to complete the project manually (line by line with copy/paste) DO NOT APPLY! I have attached a SAMPLE FILE with 5-6 products for you to check
ID-ul proiectului: 15350768

Despre proiect

56 propuneri
Proiect la distanță
Activ: 6 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
Hi, I have created preview of the macro: [login to view URL] If you award me the project, I will finish the code according to your requirements. Relevant Skills and Experience I am experienced programmer (VBA, C#, SQL) and heavy Excel user. I hope that you will be satisfied with my services. Proposed Milestones $30 USD - VBA macro
$30 USD în 1 zi
5,0 (3 recenzii)
2,1
2,1
56 freelanceri plasează o ofertă medie de $41 USD pentru proiect
Avatarul utilizatorului
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones $100 USD - Please pay me once the job is 100% complete
$100 USD în 1 zi
5,0 (637 recenzii)
8,3
8,3
Avatarul utilizatorului
Hi, I ll code a VBA macro where you will import your source file, click a button and the macro will generate the new file according to your desciption (each product in a single row). Expérience et Compétences appropriées Excel/VBA expert Étapes proposées $55 USD - m
$55 USD în 2 zile
4,9 (253 recenzii)
7,4
7,4
Avatarul utilizatorului
Hello. I can write the necessary macros to modify your data automatically. (what you need is matrx-transformation. We will use pivot tables for faster processing) Contact me to discuss further. Relevant Skills and Experience Excel, VBA, Mathematics, Data Processing Proposed Milestones $200 USD - job done How big is your data? How many records you have?
$200 USD în 5 zile
5,0 (143 recenzii)
7,1
7,1
Avatarul utilizatorului
Hey There, I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman
$55 USD în 1 zi
4,9 (170 recenzii)
6,5
6,5
Avatarul utilizatorului
More than 6 years of IT exp Relevant Skills and Experience VBA,C# Win Apps,Google scripts Proposed Milestones $35 USD - VBA
$35 USD în 1 zi
4,9 (64 recenzii)
5,7
5,7
Avatarul utilizatorului
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you.. Relevant Skills and Experience excel vba Proposed Milestones $30 USD - full
$30 USD în 1 zi
5,0 (42 recenzii)
5,7
5,7
Avatarul utilizatorului
Hi, I can build your 1-7 assignments via xlsm during a day for $100 usd. Thanks and Regards, Zura Relevant Skills and Experience I'm coding in Ms Access/Excel/ vba since Ms Office 97 released. Proposed Milestones $111 USD - default
$111 USD în 1 zi
4,7 (32 recenzii)
5,8
5,8
Avatarul utilizatorului
Your task is clear to me and I am ready to execute the project for the 30 USD. Stay tuned, I'm still working on this proposal.
$30 USD în 1 zi
4,9 (60 recenzii)
5,7
5,7
Avatarul utilizatorului
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation. Proposed Milestones $25 USD - 100% milestone and release upon completion
$25 USD în 1 zi
4,8 (68 recenzii)
5,3
5,3
Avatarul utilizatorului
I would like to present myself as a candidate for your consideration. I have successfully completed few projects for US clients which involved Excel Macros, VBA Relevant Skills and Experience Excel Macros VB.NET VBA Proposed Milestones $100 USD - This task will be completed within schedule
$100 USD în 3 zile
4,9 (40 recenzii)
5,4
5,4
Avatarul utilizatorului
Greetings, My name is Ahmed Abdelhameed, and I'm a Windows software developer with excellent problem solving and analytical skills. I'm specialized in desktop applications, tools, and scripts. Relevant Skills and Experience I have a long experience with MS-Excel (formulas & VBA macros). I also write programs using .NET since 2012, and using classic VB6 since 2007 (including VBA & VBScript). Proposed Milestones $50 USD - Project milestone Kindly check my portfolio for previous work samples. More about my background in software development: - Have long experience with web scraping applications, socket communications, FTP connections, mathematics & formulas, applications that manipulate files & folders, and creating mini-tools that automate tasks while working in background. - Very good experience with multi-threaded applications. - Very good Experience with database based applications (MS-Access, SQL Server, and MySQL).
$50 USD în 1 zi
5,0 (20 recenzii)
5,2
5,2
Avatarul utilizatorului
Hello, I can create a macro that will move the specifications of each product into the correct column and make one single row. If you are interested please open a chat with me Thanks Relevant Skills and Experience Excel VBA Attention to details Proposed Milestones $35 USD - Full payment after the project is completed
$35 USD în 1 zi
5,0 (43 recenzii)
4,9
4,9
Avatarul utilizatorului
I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Habilidades y experiencia relevante I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Htos propuestos $111 USD - Milestone
$111 USD în 10 zile
4,9 (33 recenzii)
5,0
5,0
Avatarul utilizatorului
Hello, I have checked the file and can write this macro in very efficient way, to handle even big data sets. 1st macro will check whole name column to know what columns to add. Regards Relevant Skills and Experience I'm a full-time VBA developer. I specialize in optimizing code for big data, my code is always transparent and fast. Proposed Milestones $35 USD - VBA macro written and tested. Should the output be in the same sheet and previous data removed? IsMain column will now be useless, should i skip it in the output?
$35 USD în 1 zi
5,0 (53 recenzii)
4,8
4,8
Avatarul utilizatorului
I propose to build an Excel VBA macro for converting the data. Target system is Microsoft Windows. Relevant Skills and Experience I've done a lot of VBA programs for data manipulation. Proposed Milestones $30 USD - Complete project.
$30 USD în 1 zi
5,0 (19 recenzii)
4,6
4,6
Avatarul utilizatorului
I can do the work with VBA or with C #. I have experience migrating Excel to Sql Server. I also did jobs with LinqToExcel and EPPlus Habilidades y experiencia relevante C#, VBA, LinqToExcel, EPPlus Htos propuestos $100 USD - All work
$100 USD în 2 zile
5,0 (3 recenzii)
4,2
4,2
Avatarul utilizatorului
Hi, I went through the description. This job is quiet similar to my recent project. I can do a pretty good job for you without any errors. On time delivery is guaranteed. Replies within 1 hour. Open for Discussion, negotiation. 24X7 online Thanks Regards Thushara
$35 USD în 3 zile
5,0 (24 recenzii)
4,3
4,3
Avatarul utilizatorului
Hello, thanks for your interest. I can help you write a macro to transfer your data into columns as you expected. I promise that the work will be done with the best quality. Relevant Skills and Experience I'm familiar with Excel VBA macros and ready to start the work right away. Proposed Milestones $25 USD - Completion.
$25 USD în 1 zi
5,0 (9 recenzii)
3,8
3,8
Avatarul utilizatorului
Hi. 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 Relevant Skills and Experience 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 Proposed Milestones $150 USD - complete
$150 USD în 3 zile
4,9 (25 recenzii)
3,9
3,9
Avatarul utilizatorului
I am expert in Excel VBA and I am very much interested in this project, Pls pm me for an "IMMEDIATE DEMO". Thanks, Mandeep
$68 USD în 1 zi
5,0 (9 recenzii)
3,1
3,1

Despre client

Steagul BULGARIA
Sofia, Bulgaria
5,0
39
Metoda de plată a fost confirmată
Membru din iul. 30, 2009

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.