Auto Calculate Question / HELP!

[Andy]

When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the
formulas look like:
=D21
=D22
=D23
=D24
=D25

But is there a way for Excel to be adjusted so that they attach the
information laterally instead of veritcally? For example, I want to drag the
auto fill DOWN but want the cells to read:
=D21
=E21
=F21
=G21
=H21

Thank you!

 

[T. Valko]

Try this...

Assume you enter the first formula in cell A1

=INDEX(D$21:H$21,ROWS(A$1:A1))

Drag down as needed. Adjust for the correct end of range H$21.

 

[Roger Govier]

Hi Andy

You can't do it with Autofill
Insert the following formula in the cell where you want to start (ie where
you want the value from D21 to appear) and copy down as far as required
=INDIRECT(SUBSTITUTE(ADDRESS(1,ROW(A4)),"1","")&"21")

--
Regards
Roger Govier

When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the
formulas look like:
=D21
=D22
=D23
=D24
=D25

But is there a way for Excel to be adjusted so that they attach the
information laterally instead of veritcally? For example, I want to drag
the
auto fill DOWN but want the cells to read:
=D21
=E21
=F21
=G21
=H21

Thank you!

__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com