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.
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.
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.
20 freelancers are bidding on average $70 for this job
I am an IT professional with 10 yrs experience. I have very good experience with VBA Excel Macros and Visual basic 6.0. I will provide quick & professional service.
Hi I assume you mean you would like to automate the replacing work, ie, list all phrases and let program replace them in relevant columns only in one go.
Hi we have done a quite a few application using VBA to few of the clients. This requirement is quite similar to the one we have done. request you to consider our bid.
I can create macro to replace within cells and arrange data as per our requirement. I did a 3 projects like this and reduced time lot..... Iam expecting more projects like this.