Closed

Excel VBA Visual Basic / Macro Programmer for Inventory Data

This project was awarded to nagybatonyi for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
20
Project Description

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.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online