Hi,
I've got a task of rearranging columns from 3 sheets into a new sheet(s) in
different ratios, for example if my 3 sheets are X1,X2 and X3 and my new
sheet is called Mix, my mix ratio may be 1:3:2. In this case I cut the firs
column from X1 and paste it into the first column of Mix, then the first 3
columns from X2 and paste into the adjacent column in Mix, then the first 2
columns from X3 and paste into the next adjacent columns in Mix, and carry on
like this until there is no data left to mix. I recorded a macro when I did
it manually but I'm not sure how to set up the loops for different ratios or
how to create a new sheet if 'Mix' gets filled up and there is still data in
X1 X2 and X3. Any help at all would be hugely appreciated,

Nick