thunderspeed
New Member
- Joined
- Sep 25, 2014
- Messages
- 30
hi all ,
I want to drag down a cell's formula where i need only one of the two cells involved to be changed , meaning I want to drag down and have :
=CX8200*C8
=CX8200*C9
=CX8200*C10
=CX8200*C11
=CX8200*C12
instead of :
=CX8201*C8
=CX8202*C9
=CX8203*C10
=CX8204*C11
=CX8205*C12
I want to drag down a cell's formula where i need only one of the two cells involved to be changed , meaning I want to drag down and have :
=CX8200*C8
=CX8200*C9
=CX8200*C10
=CX8200*C11
=CX8200*C12
instead of :
=CX8201*C8
=CX8202*C9
=CX8203*C10
=CX8204*C11
=CX8205*C12