Slim

In second sheet A1 enter this =OFFSET(Sheet1!$A$1,5*ROW() -1,0)

Drag/copy down Column A until you return zeros.

When happy, Copy/paste special(in place)valuesOKEsc


Gord Dibben Excel MVP


On Thu, 17 Mar 2005 10:15:03 -0800, "Slimmyy"
wrote:

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?