If you have NOTHING else in Col A in sheet1 other than these formulas, then
follow the instructions I gave you but use

=OFFSET(Sheet2!$A$1,COUNTA($A$1:A34),0) in cell A35

and then follow the rest as stated. You'll be 1 row off until you complete
cell A1.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" wrote in message
...
In cell A35 on sheet 1 put

=INDIRECT("Sheet2!A"&ROW()/35+1)

select A1:A35 and then grab the bottom corner of the range that looks like
a
little black cross and drag down as far as needed. Now go back and in
cell
A1 just link it directly to cell A1 on the other sheet.

NOTE:- If you are likely to insert or delete any rows on this sheet then
I
would not suggest this option.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"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