mrice Wrote:
That's right. I had understood that your data repeated every 12 rows,
hence the 12 in the formula. If its only 6 use

=INDIRECT("A" & 1+(6 *(INT((CELL("Row",C1)-1)))+CELL("Col",C1)-3))

instead.

If the number of rows varies, you could still achieve what you want by
macro but you would have to have a way of working out which row went
into which column.

So how can i save the rendered text after its copied itself over to the
next columns


--
onlythebest
------------------------------------------------------------------------
onlythebest's Profile: http://www.excelforum.com/member.php...o&userid=36301
View this thread: http://www.excelforum.com/showthread...hreadid=560771