Hope someone can help.
I'm writing an excel file in which, by entering certain data & values into pre defined fields, will ultimately create a list of products.
We operate an e-commerce web site and often need to import products on mass. Our web site accepts csv's for importing the data.
The data however has to be very specific & match 1to1 with the attributes already pre-defined and set up in the web site.
Some of these fields are not immediately obvious to anyone who's not used to our system.
We often have to load other clients data to our site & therefore to try to get them to create the csv in the formate we require with all the correct fields is problematic.
Therefore I'm trying to write a file which will give the user dropdown selections & pre-defined fields which will be easy for anyone to understand.
For a macro to then run to create a list of products in correct format ready for import into our system.
I've already built all the pre-defined fields. I already know the output I require.
I am however not able to write VBA myself & therefore stuck at the next stage.
THE 1st STAGE
Basically the data is entered into the fields in rows 1:45.
Then an 'ADD PRODUCT' macro button is pressed.
This will run the macro, looking at the fields entered and create a list of products from row 50 onwards.
Then the next product's information can be entered, the macro run again, and the next style add to the list of styles at the bottom of the file.
This can continue indefinitely with more & more products being added & the list at the bottom of the file to grow and grow in length.
THE 2nd STAGE
Once all the products are added & the list completed by the user, then a 2nd 'GENERATE csv' button can be pressed which will generate the csv file.
I can talk anyone through the details of what I'm trying to achieve easier once in conversation & with the files in front of you.
Thank you & looking forward to whom ever wishes to take up this challenge.
63 freelancers are bidding on average £135 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Let me help. Willing to take up your project. Thank you, Regards.
Hi, Expert in Excel programming. I have done CSV and Excel Row manipulation computations in previous projects. Looking forward to this challenge. Regards, Amit