Excel VBA Visual Basic / Macro Programmer for Inventory Data

IN PROGRESS
Bids
20
Avg Bid (USD)
$70
Project Budget (USD)
$30 - $250

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.

Skills required:
Data Entry, Excel, Microsoft, Visual Basic
Additional Files: get+a+freelancer+channel+advisor.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 75
in 1 days
Hire nagybatonyi
$ 50
in 2 days
Hire Wonderer
$ 89
in 1 days
Hire morpheeen
$ 100
in 4 days
Hire nmppatel
$ 85
in 2 days
Hire asaikiran1979
$ 100
in 2 days
Hire johnsinit
$ 68
in 2 days
Hire cheungkc
$ 75
in 3 days
Hire VBASpecialist
$ 75
in 3 days
$ 80
in 3 days