On sheet two in column A, place this formula:
=INDEX(Sheet1!$J1:$J170,COLUMN()) returns J1 from sheet1
In column B place this:
=INDEX(Sheet1!$J1:$J170,COLUMN()*17) returns the value from J17 sheet1
copy this to the right as far as needed for J34, 51, 68, 85....
then copy down as far as needed to work on J2, J3....
HTH
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=373981