Related:
- Need Help With Macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Run macro when cell value changes - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 30, 2010 at 08:08 AM
Jul 30, 2010 at 08:08 AM
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
https://authentification.site/files/23589974/SAMPLE.xls
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 6, 2010 at 11:27 AM
Aug 6, 2010 at 11:27 AM
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.
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.
