Thread: MACRO NEEDED
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AshMorK AshMorK is offline
external usenet poster
 
Posts: 24
Default MACRO NEEDED

I need a macro to convert a matrix of 2 columns and "n" rows into a matrix of
16 columns and n/8 rows, for example, to convert matrix AB to matrix A....P

A B A B C D E F G H I J K L M N O P
a1 b1 a1 b1 a2 b2 a3 b3...............................a8 b8
a2 b2 a9 b9
a10b10.......................................a16b1 6
.... ... .. .. .. .. . . .. . .. . . ... .. . .. . . . ..
.. . . .. . . ...
an bn
.................................................. ..........an bn

Tnkx