Create all 2,3,4,5 etc combinations of columns out of X number of columns

Hello to all,

I have sheet which contains a number of columns and would like to create combinations out of those columns. For example, if there are 6 columns, I would like to create all combinations of 5 columns, 4 columns , 3 columns and 2 columns - out of those 6 columns and each in their separate sheet. If the data columns are ten, I would like to create all 9,8,7,6,5,4,3 and 2 column combinations out of the 10 columns.

Also if it would be possible to set the empty columns between each generated block of data, (in the example there is 1 empty column) it would be amazing.

Thank you for looking, sans

Hi guys,

As the forum is incredibly busy I am bumping the thread so it doesn't get lost. If anyone can offer some help it would be great.
Thank you

Update: If anyone is interested, I have received a solution for the above in the code cage forum, if you'd like to have a look, here's the thread:

http://www.thecodecage.com/forumz/mi...post1055003713