Copying a formula down a column

M

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
 
F

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.
 
B

Bernard Liengme

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

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.
 
F

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.
 
E

Excelfan

It sure works!
My bad of course. Thanks.

Fred Smith said:
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.
Click to expand...
 
M

Mike Stewart

Thank you Fred it saved me 3 hrs of typing.

Fred Smith said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
SUMIFS formula using dates and text as criteria 3
Copy addition formula of non-consecutive horizontal cells 2
numbering lines 3
Format column widths from one table to a separate table on same page 1
How to select one record of each from a column 2
If then formula with multiple cells 2
help with Sum in between dates 12

Top