Just to add on to what Fred Smith has posted ..

Use absolute referencing for cell C6. Below are the different reference
styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

Alternative solution without using formulas is
--Copy cell C6
--Keeping the copy; select the range C8,c9,c10... etc;
--Right clickPasteSpecialDivideOK.


If this post helps click Yes
---------------
Jacob Skaria


"LRM" wrote:

I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM