=($A$4 *B6)
Vaya con Dios,
Chuck, CABGx3
"ISMEGORDO" wrote:
Hi there all,
I know it can be done I just forget the naming of this cell
I want to have several Cells that the formula in it has One Particular cell
in it, I want to then be able to click and Drag this formula Down the page to
Autofill the celles bello, But that one Cell (in the formula cannot change)
ie:Cell D2 =(A4 *B6)
Cell D3 =(A4 * B7)
And So On I am Pretty sure that the cel A4 had ! in it to keep that from
moving to the next cell when auto filling
Any Idead Thanks In Advance
Gordon
|