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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560771