I have an Excel spreadsheet that contain several blocks of data. Eac
block contain a random number of rows but each row have a maximum o
twenty columns.

I need to transfer the data from each block and row by row by Cut an
paste. There are many blocks and a macro is required. My majo
difficulty is that the rows in one block must be transferred to
single row, separated by a blank column, prior to pasting the next ro
and so on. The next block should be paste into row two and repeat unti
the entire blocks are transfered. An additional problem that migh
arise is that if one block requires more that 256 column, then th
additional row must be pasted on sheet two, or three if need.

Any advice..... All are appreciated

--
Message posted from http://www.ExcelForum.com