a1=INDIRECT("sheet1!a"&2+(ROW()-1)*4) copy down the formula
it copies the value of sheet1-a2 first, sheet1-a6, a10, ..
with regards
sreedhar

"HighlandRoss" wrote:

Hi

I am trying to create a formula to copy data from one workbook to another.
The problem I have is that I want to copy only relevant data which is in
every 4th column.

So in cell A1 (destination sheet) I copy from A1 then A2 I want to copy from
A6, then A3 I want to copy from A10 and so on. Then the same for numerous
rows.

I need a formula that I can drag across so that I don't have to type a
formula for each instance because I will be using all available columns.

Hope that makes sense and someone can help. Thanks in anticipation!