For Example:
Columns A thru E
(A)Test Date_(B)Oil_(C)Gas_(D)Water_(E)Total Fluid
10-07-09_314_365_2116_2430

When I enter oil, gas and water volumes, i want the total fluid to calculate
and fill down automatically using volumes from Columns B(oil) & D(water).

Total Fluids = B+D

"Dave Peterson" wrote:

I'd look for "helpful" macros first--but that's because I like macros.

You may want to look to see if you're using a List (xl2003) or Table (xl2007).
Maybe those offending columns are not part of the list/table.



KLUG wrote:

I'm working on a spreadsheet build by someone else. Some formulas
automatically drag down & calculate when certain data is entered. When I add
the same data for other columns with formulas, I have to drag the formulas
down to calculate. I can't find a difference when I investigate the columns
that do this and the ones that do not. Does anyone know why?

--

Dave Peterson
.