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

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.

"Mike Stewart" wrote in message
...
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

If there is data in an adjacent column, then the easiest way is to double
click the fill handle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fred Smith" wrote in message
...
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.

"Mike Stewart" wrote in message
...
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

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.

"Bernard Liengme" wrote:

If there is data in an adjacent column, then the easiest way is to double
click the fill handle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fred Smith" wrote in message
...
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.

"Mike Stewart" wrote in message
...
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

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" wrote in message
...
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.

"Bernard Liengme" wrote:

If there is data in an adjacent column, then the easiest way is to double
click the fill handle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fred Smith" wrote in message
...
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.

"Mike Stewart" wrote in message
...
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

It sure works!
My bad of course. Thanks.

"Fred Smith" wrote:

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" wrote in message
...
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.

"Bernard Liengme" wrote:

If there is data in an adjacent column, then the easiest way is to double
click the fill handle
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Fred Smith" wrote in message
...
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.

"Mike Stewart" wrote in message
...
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

Thank you Fred it saved me 3 hrs of typing.

"Fred Smith" wrote:

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.

"Mike Stewart" wrote in message
...
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

You're welcome. Thanks for feeding back.

Regards,
Fred.

"Mike Stewart" wrote in message
...
Thank you Fred it saved me 3 hrs of typing.

"Fred Smith" wrote:

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.

"Mike Stewart" wrote in message
...
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