https://www.lotterypost.com/thread/252955 Lottery Post Forum Topic: need help writing permutation macro en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/252955/2814897 https://www.lotterypost.com/thread/252955/2814897 Wed, 05 Dec 2012 04:44:12 GMT LottoBoner

]]> LottoBoner https://www.lotterypost.com/thread/252955 https://www.lotterypost.com/thread/252955 Thu, 08 Nov 2012 19:27:01 GMT scott989 I dont know how to write a macro in excel, need some help. when I write any number between 1 to 5 in cell(1, F) the macro should generate all the possible permutation. The numbers should come in differnt cell.

For example

If I enter 3 in cell(1, F)

outcome should start form cell(49, G) in this patern

1 1 2 2 3 3

2 3 1 3 1 2

3 2 3 1 2 1

all number should come in different cells.

Thank you in advance.

]]> scott989