Using the fill command is there a way to increase by columns instead of row

[Auger]

If anyone can help thanks

Worksheet1 has something like
Monday 1-1-04
Tuesday 1-2-04
Wednesday 1-3-04
etc

Worksheet 2 has something like
1-1 1-2 1-3 etc
2 3 4 etc
4 5 6 etc

6 8 10 etc

When I reference the data in Worksheet 1, in B1 I put =Worksheet2!A5
and when I fill down the formula I get =Worksheet2!A6 in B2 and
=Worksheet2!A7 in B3 example:

Monday 1-1-04 =Worksheet2!A5
Tuesday 1-2-04 =Worksheet2!A6
Wedne 1-3-04 =Worksheet2!A7

what I'm trying to do is have the info reference like so then the
column changes like:

Monday 1-1-04 =Worksheet2!A5
Tuesday 1-2-04 =Worksheet2!B5
Wedne 1-3-04 =Worksheet2!C5

I know I can do a mixed reference with =Worksheet2!A$5 so the row will
remain the same but I don't know how to increase it by column. I
don't know if its possible or should I just change the data in
Worksheet 2 where the totals are vertical. TIA

 

[Frank Kabel]

Hi
instead of
=Worksheet2!A5
enter the following formula
=OFFSET(Worksheet2!$A$5,0,ROW(1:1)-1)
and copy down

 

[firefytr]

only since i'm not a big fan of OFFSET:

=INDEX(Worksheet!$A5:$A20,COLUMN(A1))

or whatever range you want