you have not given how many values are there in sheet1 and column A. I
assumed only 10 values.
if different change the line
i=1 to 10
then use this sub

Public Sub taest()
Dim i As Integer
Dim j As Integer
For i = 1 To 10
Worksheets("sheet2").Cells(35 * i, 1).Value = Worksheets("sheet1").Cells(i +
1, 1).Value
Next i
Worksheets("sheet2").Range("a1") = Worksheets("sheet1").Range("a1")
End Sub
===================================
JIMMY wrote in message
...
This is best described by example:
I need Sheet 2, Cell A1 to reference Sheet 1, Cell A1. Sheet 2, Cell A35
to
reference Sheet 1, Cell A2. Sheet 2, Cell A70 to reference Sheet 1, Cell
A3.
Etc.

How do I do this!?
--
JIMMY