VBA Permutations of data string

Power sellers on Amazon and ebay will especially find this VBA solution useful to help create the multiple descriptions required to mix and jumble up their wordings and ultimately increase the SEO of their site and products. This particular code takes all the keywords in a matrix on the activesheet that are in cells A1:E6 and lists the different permutations from each. A good example here would be clothing where each column A:E represents a different ‘element’.

The code will identify which cells are not used and create the permutations against each column. In this example the first few outputs would be:

Large Red Tshirt
Large Red Shirt
Large Red Shorts
Large Green Tshirt

…right through to the last…

Small Orange Short

You will need to copy this entire code into a module and assign it to a button or a macro name in the workbook. It can be adapted and expanded to allow for a huge amount of data and permutations, potentially saving hours of thinking and work and above all, absolute accuracy.

Feel free to leave us a message or contact us through the form below to help create a larger matrix or implement this in your project.

Datanology

2 thoughts on “VBA Permutations of data string”

Yes, the data would be output into a .txt file and would be easy for you to manage in a text editor or importing into your website if applicable. We would just need the data, and the process would be run, giving you your output almost immediately,

Hi, I have over 10,000 items in 4 columns that I need to be output in each separate permutation with a prefix and suffix of a pipe delimiter |. This exceeds Excels 1.04million rows. Do you have a solution for this ?