Auto Fill

[Chuck Haynes]

I want to auto fill in a differant direction. I know how
to fill both vertically and horizontally. I want the
formulas that are arranged horizontally to fill
vertically. I have tried to hold the alt and or the ctrl
key while auto filling but that didn't work.

I'm trying to explain this a plain as possible, sorry for
the confusion.

Chuck

 

[RagDyer]

Don't know if I quite understand you, but what happens when you select the
row of formula containing cells and simply click on the "fill handle" and
drag down to copy ?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I want to auto fill in a differant direction. I know how
to fill both vertically and horizontally. I want the
formulas that are arranged horizontally to fill
vertically. I have tried to hold the alt and or the ctrl
key while auto filling but that didn't work.

I'm trying to explain this a plain as possible, sorry for
the confusion.

Chuck

 

[Chuck]

It auto fills downward using the formulas values, however
I want the values to the right not the ones moving
downward. I think I have found a solution to my problem.
I'm moving my formulas to the left of my data and then
auto filling. I'm then relocating the the new values to a
new location. Sorry for the confusing description.

Chuck

 

[RagDyer]

I'm still confused, but you make it sound like you should be looking up
Relative and Absolute references.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

It auto fills downward using the formulas values, however
I want the values to the right not the ones moving
downward. I think I have found a solution to my problem.
I'm moving my formulas to the left of my data and then
auto filling. I'm then relocating the the new values to a
new location. Sorry for the confusing description.

Chuck

 

[Peo Sjoblom]

RD,

I assume he means that he wants to extract info from the right while
dragging the formula down,
one way is to use offset and here's an easy example

=OFFSET($B$1,,ROW(1:1)-1)

if you copy it down it will retrieve what's in B1, C1, D1 and so on..

 

[RagDyer]

24 hours now Peo ... I guess we'll never know !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

RD,

I assume he means that he wants to extract info from the right while
dragging the formula down,
one way is to use offset and here's an easy example

=OFFSET($B$1,,ROW(1:1)-1)

if you copy it down it will retrieve what's in B1, C1, D1 and so on..