Excel VBA Visual Basic / Macro Programmer for Inventory Data

Budget $30 - $250 USD
Bids 20
Average Bid $70

Excel VBA Visual Basic / Macro Programmer for Inventory Data input.
We are currently in the process of creating multi variation listings for Ebay which consist of a parent Sku inventory item with the child variations attached to the parent.
For example;
Parent - Get a freelancer T shirt All Sizes
Child - Get a freelancer T shirt Small White
- Get a freelancer T shirt Small Blue
- Get a freelancer T shirt Small Black
- Get a freelancer T shirt Large White etc etc etc

There are @ 70 child variations for each inventory item. There are @ 600 inventory items in total.

The spreadsheet is already partly populated with inventory items and all the correct relevant data but what i need is a program or macro creating to automate this process.
I currently make all the changes by using the REPLACE function to replace the item title (only the first part of the title is replaced. The information such as size and colour is left in each cell.
The REPLACE function also replaces the image url etc so this is not a real complicated program.
It needs to be accurate and fast, thats all I need.

I would give a list of all the different inventory title ammendments, SKU numbers and ebay store category names.
eg ammendments
Inventory Inventory Number Picture URLs Variation Parent SKU Ebay category
Column A Col C Col Z

Mr T A-team Movie 001 change part of URL with 001 in. change to 001 funny::TV

That is it really. The macro/program will need to change characters within a cell (eg URL filename)

I will be looking at lower bids for this project but I hope to use the winner for many tasks in the future, for many diverse jobs.

I have attached part of the spreadsheet for you to see.
Please PM if you have any more questions.

Post a Project Like This

This project was awarded to

nagybatonyi

This was my first occasion to use Freelancer.com, and my experience was very positive due to the excellent professionalism, service and communication provided by nagybatonyi. He performed the work exactly as I had hoped, was responsive, gave me a quick turnaround, was patient with me in getting back to him on questions he raised, and I would definitely use nagybatonyi's services again. In fact, I am looking forward to it.
About the Freelancer
nagybatonyi Profile Picture

University degree in economy and mathemathics, 30 years of system design and programming in more languages, recently 15 years Excel/VBA experience in office automation.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • dblancer Profile Picture

    dblancer

    Kharkov,  Ukraine

    Result-oriented professional with more than 10 years of experience delivering high quality IT solutions on time and on budget. Strong technical background to make well-grounded decisions on system architecture design. Development Experience: - C#, VB.Net, WinForms, WPF - Web-services (ASMX, WCF), Windows Services - XML, XSLT - .Net Remoting, COM - MS SQL Server 2000/2005/2008, MySql, MS Access - Word, Excel automation (OLE, DDE, COM) - IE automation - VB, VBA, VBScript - Shell scripting, installation packages (msi) - UI design for deskop applications - Client/server systems

    ASP, Javascript, XML, and Visual Basic

  • ManojkumarPatil Profile Picture
  • ilyaskazi Profile Picture

    ilyaskazi

    Mumbai,  India

    Technocrat with 4+ years of experience in PHP MySQL EXCEL VBA macro development served Shipping, Airline, and BPO Segments. Strong analytical, problem solving & organizational abilities. Possess a positive, flexible & detail oriented attitude, strive to be my best. Concerned with quality. Produce work that is orderly and attractive. Ensure tasks are completed correctly and on time.

    PHP, Visual Basic, Excel, and eCommerce

  • morpheeen Profile Picture

    morpheeen

    Paleu,  Romania

    Microsoft certified web application developer (MCTS 70-515), with 9+ years of programming experience (ASP .NET, Windows Azure, MVC, C#, VB.NET, JQuery, Html5, CSS, Angular JS, Kendo UI/Dataviz, TDD, Entity Framework, Sql, MySql, PHP, Smarty, API Integrations, etc). Clean code, following best practices. If the customer is happy I am happy.

    PHP, ASP, XML, and Visual Basic

  • trupti Profile Picture

    trupti

    Mumbai,  India

    Over 18+ years of Solid Professional experience in developing Desktop, Client/Server, Component Development, Mobile Development, Database Development, and distributed applications as well. Extensive exposure in object oriented programming (OOPS). I provide development solutions and services for Mobile , Desktop, Client-Server/Remote and Database Related applications. I also provide Data Entry, Data Collection, Data Mining, Data Warehouse, and related services and solutions. Sun Certified Java Programmer (SCJP). I develop applications for clients as per their needs and requirements. I Believe in providing Quality Work with best solutions and Timely Delivery with Client's Complete Satisfaction. From 2000 till date, I work as a Freelancer Software Developer/Consultant under the name of Terry Consulting. terryconsulting.wordpress.com

    Java, XML, Visual Basic, and .NET

  • nagybatonyi Profile Picture

    nagybatonyi

    Budapest,  Hungary

    University degree in economy and mathemathics, 30 years of system design and programming in more languages, recently 15 years Excel/VBA experience in office automation.

    Visual Basic, Excel, PDF, and Word

  • naveengopinath Profile Picture
  • israelis Profile Picture

    israelis

    Tuticorin,  India

    Technical Skills: Accounting Package : Tally 7.2 Packages : MS-Office Strengths: 1 Excellent knowledge in Excel Macro. 2 Punctual Hardworking and determined towards goals. 3 Proactive and enthusiastic to learn new technologies and tools. 4 Ability to grasp easily and implement it with minimal assistance.

    Excel, Microsoft Access, and Visual Basic for Apps

  • mongkolchon Profile Picture

    mongkolchon

    Bangkok,  Thailand

    I have 7-year exp. in investment and excel. + pricing/risk/return/monte carlo/etc. + formula/function/macro/vba/etc. My work is very neat and I do it fast!!

    Excel

  • jayasundarak Profile Picture

    jayasundarak

    Gampaha,  Sri Lanka

    I am a skilled engineer in the field of industrial automation, machine design and vision based automation with industrial experience of 9 years (after graduation). Also I hold a MPhil degree in power electronics and drives. With design experience of more than 100 new machines and projects, I am very confident in my field.

    Visual Basic, Data Processing, Engineering, and Electronics