Permutation Macro for Excel
$30-250 USD
Paid on delivery
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.
Project ID: #762392
About the project
Awarded to:
36 freelancers are bidding on average $51 for this job
Hello - My bid is for an Excel 2007 VBA script. Please send file with sample data. Thank you. Chandra Ram
Dear Lorien! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
I have lot of experience in writing Excel Macros. I can do this for you quickly and accurately.
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
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