running total of columns

[Dee R]

I have a spreadsheet that tracks comp time for each employee. The columns
headings are: Date Worked/Taken; Straight time: 1.5 time; Total Earned
Hours; Comp time hours; Balance of Comp Time: Date leave must be taken (90
days from earned date) I have the formulas for each column, but how do I
keep from copying the formula to each cell each time. If they have 300 hours
in the balance of comp time column; that 300 will show in each line below the
total until I enter new data in the line. I know I can wait until I enter
the data then just copy the formula to the correct line, but if I can figure
out how to just show the total after each entry then other departments want
to use this spreadsheet.

 

[David McRitchie]

Hi Dee,
Usually a running total or a balance is put on the same row.
I'm not sure if that is what you want or if you want it below the last
data row.

I think you want it on the same row and are concerned about having
additional formula on rows below set up with formulas. You can
use an Event Macro to fill in the formulas for you. example see
Worksheet_Change event (#ChangeEvent)
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#ChangeEvent
also read about Extended Formats and Formulas (#extended)
immediately below the above topic. If all fields are filled in exactly
like the previous row then Extended formulas will kick in.if at least
3 of the preceding 5 rows have the same formulas. .

 

[Earl Kiosterud]

Dee,

You have to cheat a little. We do that all the time around these parts.
Use Format - Conditional formatting. First select the cells. Format -
Conditional formatting - Formula.

=A2=A1

This is for where A2 is the active (white) cell of your selection (use Enter
or Tab keys to change active cell after making your selection). Change as
appropriate. For the format part, select white for the font color. It'll
still be there, but it won't show, nor print.