Complex Autofill does not follow formula

[The Life Coach]

I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
Column C has set values starting from row 6.
E6=E4*C6
E7=E4*E4*C7
E8=E*E4*E4*C8
E8=E4*E4*E4*E4*C9

F6=F4*C6
F7=F4*F4*C7
F8=F4*F4*F4*C8
F9=F4*F4*F4*F4*C9

if I use autofill by dragging across to fill columns G onwards the C7
becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct
G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of
=F4*F4*F4*F4*F4*C10.

All help gratefull received as I have have to extend this table in both
directions.

OS is XP Home - excel is 2002

Many Thanks

 

[Bob Phillips]

=$E$4^ROW(A1)*$C6

and so on

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[The Life Coach]

Dear Bob,

many thanks - could you expand on that a bit please - I assume you mean i
repce my existing formulas with a variant on your suggestion - how would they
look for say cells E6,E7,F6&F7.

Many thanks again

Andy Smulian

 

[Bob Phillips]

If you put this slightly modified version in E6

=E$4^ROW($A1)*$C6

you should be able to drag it across and down and get what you want

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[The Life Coach]

Bob,

A huge thank you - I'll look up those symbols and learn how to use them for
myself now - again - many many thanks.