I'm trying to build a workbook from project plan that keeps a running total

of actual hours. The only problem I'm having is with this summation

question. Numerous employees are entering their weekly hours for the current

week. How do I build a function that adds current weekly hours to the

previous weekly hours in my Actual hours column?

TD

What you probably need is a little macro that copys the current cumulative

total (previous hours + weekly hours reported) back up into the previous

hours cell and zeros out the weekly hours reported to use at the end of a

week.

Assume that the Previous Hours is kept in B5, that weekly hours for

employees are in C10 through C20, and the the cumulative total of all is in

D21, you could have code like this

Sub StartNewWeek()

Range("B5") = Range("D21")

Range("C10:C20")=0

Exit Sub

total (previous hours + weekly hours reported) back up into the previous

hours cell and zeros out the weekly hours reported to use at the end of a

week.

Assume that the Previous Hours is kept in B5, that weekly hours for

employees are in C10 through C20, and the the cumulative total of all is in

D21, you could have code like this

Sub StartNewWeek()

Range("B5") = Range("D21")

Range("C10:C20")=0

Exit Sub

1. best way to sum a column with #N/a's?

2. "Matching" column A's values in column B

3. Adding a sum of column on previous page in the first row of current page

4. Counting A's in a table column 1, F's in column 2, etc...

5. Select Sum(table1.column), Sum(table2.column)

8. Macro to Sum Two Adjacent Columns as per Text in previous Column

9. Macro to Sum Two Adjacent Columns as per Text in previous Column - Help required

10. Highlight row and column for the current cell,anyone re-write it to Add-Ins?

11. Can only remove add-ins but cannot add add-ins in Outlook 2003 anymore

12. Can I SUM column C IF Column A=X AND Column D=Y?

13. Trigger to add sum of other columns in one column

14. Excel add-ins does not show up in Excel>Tools>Add-ins list.

15. Solver in add-ins folder, but not in add-ins under tools menu

2 post • Page:**1** of **1**