Copying a formula down a column

[Mike Stewart]

I have made a expence jurnal, column c is the account numbers eg, 6000 for
rent
6001 elect.
Across the shet I have hedders column D Rent, Column E Elect and so on
across.
The question I have is, I have to copy into each box under rent =IfC4=6000
then the dollar amount is automaticly put into the d column on the same row.
As it is now I have to go throu each row under column d and type the formula
due to the fact that it has to state in the function box then save it each
time
I have figuard out the farmula, I just don't know how to make it change for
each row.

Example:

A B C D E F
Date Who Check Acount# Elect Rent
3 X XX 123 6000 500.00
4
5
6
7
8
9
and so on

Hope this is enough info.
Mike

 

[Fred Smith]

You change it for each row by copying the formula down the column.

The easiest way to copy the formula is to drag the fill handle. The fill
handle is the little black box on the bottom right of the cell. Click and
drag it down your column. Excel should adjust your formula as needed.

Regards,
Fred.

 

[Bernard Liengme]

If there is data in an adjacent column, then the easiest way is to double
click the fill handle
best wishes

 

[Excelfan]

You lost me there Bernard :
double click in the fill handle?
it does not do anything. Maybe this is for XL 2007
I have 2003.

 

[Fred Smith]

It works in 2003 too. It will copy the cell down as far as there is data in
the column to the left.

Regards,
Fred.

 

[Excelfan]

It sure works!
My bad of course. Thanks.

It works in 2003 too. It will copy the cell down as far as there is data in
the column to the left.

Regards,
Fred.

 

[Mike Stewart]

Thank you Fred it saved me 3 hrs of typing.

You change it for each row by copying the formula down the column.

The easiest way to copy the formula is to drag the fill handle. The fill
handle is the little black box on the bottom right of the cell. Click and
drag it down your column. Excel should adjust your formula as needed.

Regards,
Fred.

 

[Fred Smith]

You're welcome. Thanks for feeding back.

Regards,
Fred.