Need some work done? Post a Project Today
very simple excel macro required.
what i require is a macro to be created for an excel document, for the purposes of creating new products on our website.
in order to load the data into our website, we need to create an outputted csv file, all our tshirts come in 7 different colourways, and in order to load onto the website, we have to create simple products for each colourway and for each size, so if we have each tshirt is 7 different colours and 6 different sizes we have a lot of data just for one tshirt - 58 lines in total.
in order to help with this process we require a simple macro, so that we can simply list the product names and that all the data will then be created automatically for the products on that list, the task is made easier as the majority of the data will be the same with only 4 columns of data being dynamicly-related to the product name, - lookup tables exist already.
full examples of the work can be supplied.