I need a visual basic macro that will combine 4 lists into every permutation of the list. The data will be in 4 columns. And I'd need all combos of that data. The columns might have different lengths of data (ie column 1 might have 20 values, where column 2 only has 10, column 3 has 12, column4 has 3 values or something. Each one could change, of course.
Id need the output to be in a single column with spaces between each word in the permutation. Ouput should appear on the same sheet, underneath the 4 columns of original data. The outputed data should be selected for me so it's easy to copy without having to select everything. When running the macro, previous data would be removed so I don't have to do it manually.
If I had to guess, the outputted data would never exceed 200 rows. So no sort of excel sheet limit (if there are any) should apply.
Must work in excel 2007.
38 freelancers are bidding on average $50 for this job
Hi, You would be better off having the combined data in column "F" so you can copy the column quickly. You can have the result two hours after I see that my bid has been successfull. regards, Neil
Hi, I can help you with this. There is 2 way of doing this. I can make you a macro to do this or I can make an array function. Which one do you prefer ? Winata