hi,
not sure how much data you have but.....
Hold down the ctrl key while selecting every 5th cell. use
the mouse to select.
then copy. when you paste, it will paste as a group ie not
spaces between.

>-----Original Message-----
>I am trying to copy and paste cells from one sheet to
another. The problem
>is that I want to copy every 5th cell in a column and
place the data into a
>new column in one-cell incremnets. Any suggestions on
how to do this?
>.
>