Firstly in the VBE I notice the you have Sheet2 (Storeman Sheet), and Sheet3 (Sheet2). Will that cause an issue down the track?
Capture.JPGCapture2.JPG

Not seeing Sheet3 or Sheet2 anywhere in the code. "Sheet2" in "Sheet2 (Storeman Sheet)" is the .CodeName, and "Sheet1" in "Sheet1 (Sheet1)" is the .Name


Also, the count for the number of times an excuse has been used does not increase.


I didn't know if you wanted the count by Lad or just totaled since I could interpert
So only one submitted reason per day if possible.
several different ways

a. #times used by any Lad any Date - #reasons x 2 -- keep going forever, what you have in now
b. #times used by each Lad any Date - #reasons x # Lads x 2 -- keep going forever, add column for each Lad
c
. #times used by each Lad by each Date - #reasons x # Lads x #days -- keep going forever, add Date column and column for each Lad

d. #times used by any Lad today - #reasons x 2 (reset each day)
e. #times used by each Lad today - #reasons x #Lads x 2 (reset each day)