One way ..

In Sheet1
-------------
in A1 down, you have

1
2
3
etc

In Sheet2
------------
You have some existing values / labels in A2, A3, A5, A6, etc
and you want to put the values from Sheet1's col A into A1, A4, A7, etc

Use an empty col, say, col E

Put in E1:
=IF(MOD(ROW(A1),3)=1,OFFSET(Sheet1!$A$1,(ROW(A1)+2 )/3-1,),IF(A1="","",A1))
Copy down

Copy col E and
Right-click on A1 paste special values ok
to overwrite col A

This should give what you're after ..

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Joby" wrote in message
...
Thanks, although I think my explanation was misinterpreted what I ment was
in
sheet 1 you have in column A1

1
2
3

and in sheet 2 you want:

Cell A1=Cell A1 Sheet 1

Cell A4=Cell A2 Sheet 1

Cell A7=Cell A3 Sheet 1

The blank cells inbetween have left alone because there is other and
labels
in those.

Thanks

Joby