Hi,

Wonder if its possible to solve the problem I have with VBA (can solve it with macro but want it on VBA).

Possible an if-statement that check if any values in column "X" does have and negative values. If it has an negative value, then I want it to chec

Hours Person Date Type
-3 Jamie Smith 2014-12-01 Study
4 Jamie Smith 2014-12-01 Study

Generate in sheet:
Hours Person Date Type
1 Jamie Smith 2014-12-01 Study

If it has negative value that are based on same person, date, type then it need to subtract the hours.

Thnx in advanced!