need Excel Macro with array function

i need to arrange 4 columns and 28 rows data into multiple sheets with cross combinations



C1 C2 C3 C4

R1 a a a a

R2 b b b b

R3 c c c c

R4 d d d d



C1 C2 C3 C4

R1 aaaa aaab aaac aaad

R2 abaa abba acca adda

so on upto 28 rows and 28 columns


any suggestions


By: N

Leave a Reply

Your email address will not be published. Required fields are marked *