Help with decision

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create something that will track the ammount of files that are
received by employees. It needs to be perpetual. I am not sure how to do
this. Please advise.

Thanks
Drock-13
 
Assume that you know whenever an employee receives a file.

list the employee names in column A

Enter the following macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("B:B")
If Intersect(Target, r) Is Nothing Then Exit Sub
Application.EnableEvents = False
Set t = Target.Offset(0, 1)
t.Value = t.Value + Target.Value
Application.EnableEvents = True
End Sub

just enter the number of files received in column B. Column C will
automatically update with the new accumulated value.

For example Joe is row 1. Joe receives 3 files. You type 3 in cell B1 and
cell C1 automatically becomes 3. Tomorrow Joe receives 16 more files. You
type 16 in cell B1 and cell C1 updates automatically to 19.


It is perpetual because it only uses 3 columns.
 
Back
Top