Spreading a list.

J

JIMMY

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!?
 
K

Ken Wright

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.
 
K

Ken Wright

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.
 
Top