Fill-in formula which calculates automatically

  • Thread starter Thread starter KLUG
  • Start date Start date
K

KLUG

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?
 
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.
 
Thank you for the advice I learned so much by checking out helpful macros.

It looks like I need to use a Do....Loop macro using While as my condition.
Haven't figured out how to write the VBA for that yet.

I need to use a formula if certain cells are not blank <> " "

I know I need to use +1 to act on the next row. Something like:

Do While Cells (x,1).Value<>" "
x = x+1
y = y+1
Loop
 
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
 
Back
Top