Format Column with Same Function

[Guest]

Hey guys.

I'm trying to format all the cells in column G with the following function:
=E2-F2

How would I format the column so that when data is entered into E2 & F2, G2
would automatically update with the value?

I have tried
=$E2-$F2
and
=E$2-F$2

Both don't work. Any help would be greatly appreciated.

 

[Max]

Maybe just ..

Put in G2: =E2-F2
Copy G2 down

 

[Guest]

Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

~Brett

Maybe just ..

Put in G2: =E2-F2
Copy G2 down

 

[Guest]

Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

But that's exactly what you should get when you copy down the formula from
G2 ??

In G2: =E2-F2
copied down, you'll get:
In G3: =E3-F3
In G4: =E4-F4
and so on

when you copy down, what are you getting in G3, G4 ?

perhaps calc mode is inadvertently set to "Manual"?
Press F9, does it compute properly now in G3, G4, etc ?

To check / change the calc mode:
Click Tools > Options > Calc tab
Ensure "Automatic" is checked > OK

 

[Guest]

That's great, you were right. But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00" and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

 

[Max]

That's great, you were right.

You're welcome !

But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00" and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

sorry, I'm not sure on this new Q of yours
do hang around awhile for insights from others

 

[Gord Dibben]

Brett

"Automate" usually means the use of VBA code.

Do you want to go this route?

David McRitchie has an InsertRow macro which will add a formula into an
inserted row.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Ron de Bruin has several macros for copying data.

http://www.rondebruin.nl/copy1.htm


Gord Dibben Excel MVP