In sheet2, type this in cell A1

=IF(ISBLANK(Sheet1!A1),"",IF(MOD(ROW(Sheet1!A1),9) = 1, Sheet1!A1,
""))

Drag the fill handle right and down as much as you need.

Now you have copied those cells you wanted, but to formalise the
values, you just copy the cells on sheet2, and then paste special back
on the selected area, values.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=550710