I need help with an issue, but not sure if it can be done.
I want to monitor a set range and if the user enters a value greater than 50.00 - then is would leave 50 in that targetcell and the remaining value in the cell immediately below it.
If Not Intersect(Target, Range("C20:G20, C22:G22, C24:G24, C26:G26")) Is Nothing Then
complete the calcuation........
In example: If C20 entered was 51.00 then C20 would change to 50.00 and C21 would be 1.00.
I will only be using positive numbers in the target range.