fairly easy (i thought) copy and paste cells, increment by 17 accross
 

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

didnt think to use index, will try that tomorrow
thanks muchly


--
bleugh
------------------------------------------------------------------------
bleugh's Profile: http://www.excelforum.com/member.php...o&userid=23720
View this thread: http://www.excelforum.com/showthread...hreadid=373981