Need Help With Macro

[Closed]
Report
-
 Neo -
Hello,

I have attached a sample of what I would like done.

https://authentification.site/files/23532726/SAMPLE.xls



2 replies

can anyone help with this ?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I think you have a similair solution done before. it was for some other column but idea was pretty much same
I have removed the password from the file, so that you can see what macros currently exist. I don't believe any of them will do what I want done in this instance. Thanks

https://authentification.site/files/23589974/SAMPLE.xls
can you remodify the code to add what I want done.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
no file found
https://authentification.site/files/23689353/SAMPLE.xls

This is how I envision this working. At the beginning of the year column L will be filled in with a range of numbers ranging from 0 to a maximum value of 10, at this point whenever an S is entered 1 must be subtracted from the total in column L, if this total is 10 then it would then be 9, if the total is already zero, then the message box would appear at this point, prompting the user that there are no more sick days available. The message box only appears when the total in column L is at zero and the user attempts to enter S.

The employee gets back his sick days on his anniversary date, eg. the hire date for someone is 1-20-90, the number in column L has to automatically be reset to 10 on this date, 1-20-2011, so if the number in Column L was 2, then it would go back to 10. When this happens the cycle outlined above will repeat itself.