Good afternoon to all....

I have a sheet with several blocks of data- each block is separated b
a blank row. (Please see attached file for an example)

Each block contain the same number of rows but can contain a variabl
number of columns. Each cell will contain a single text character.

The macro code should cut each row from each block (based on row #) an
paste into a new sheet but in the same row as the row# from th
original sheet. So, from each block, row #1 will pasted (consecutively
into row #1 in the final sheet. Similarly, row #2 from each block wil
be pasted into row #2. This process is continued until every row i
each block are pasted into the final sheet.

In the attached file, the before sheet is for block prior to cut an
paste operation while sheet "After" is for desired outcome by using th
macro. Note the row is colored to clearify the purpose of this posting


One note, if the row size happen or require to extend beyond the limi
of 256 column, the remaining text (or rows) are pasted on the nex
sheet but under the same row # as the continuation of the row on th
preceeding sheet.

Thanks for all your help and advic

Attachment filename: sample same block.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61380
--
Message posted from http://www.ExcelForum.com