Hello,

I am trying to write a macro or something that would allow me to enter a number into one cell, then after pressing enter or some other recorded funtion, it would add into the total column and then go blank. Here is how my sheet is setup, it is used for recording time on projects/job schedules:

Column A = Name of employee (39 employees listed)
Column B = Job/Time code (37 codes total)
Column C = First column of time entry
Column D = Totaling column for time entered into Column C

Column's C - GS (every other column pattern) will be the data entry fields
Column's D - GT (every other coumn pattern) will be the summing field

Row's 2 - 1444 will be the adding/resting rows
Row's 1445 - 1481 are the totaling rows which add all the time invested into the project/job.

I have found similiar funtions, but none that allow me to schedule it through the whole sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns(2)) Is Nothing Then Exit Sub

Application.EnableEvents = False
Range("A"&Target.Row) = Range("A"&Target.Row) + Range("B"&Target.Row)
Range("B"&Target.Row) = ""
Application.EnableEvents = True

End Sub

Thanks in advance for your feedback.