I have a spreadsheet which is used to produce a printable staff roster . It uses vlookup to place most of the information .
main issues are:
Not wanting to reinvent the look , I thought that some of the errors could be eliminated with some error checking code
I was thinking of chopping it into tasks
Task one
Command button check for duplicates in cells and highlight for each day ( colour red) . if ok then msg "no errors
Task two
command Button Check names against a seperate list of staff who are on leave and highlight these names ( colour blue) .Staff could be ,not rostered or sick or on leave
The thinking behind each day having a separate command button to check is because the staff member is often pulled away or interrupted
Ï didnt want to go to a form , thought that was too complicated and trying to think through logically and modify what is already there
Having a hard time finding code to find and highlight cells in a column. Thought that would be easy not so
Is this realistic ? Any guidance , constructive comments would be appreciated
main issues are:
- constant duplication of names
- constant errors i.e rostering people when on leave
- takes an age for someone to compile
Not wanting to reinvent the look , I thought that some of the errors could be eliminated with some error checking code
I was thinking of chopping it into tasks
Task one
Command button check for duplicates in cells and highlight for each day ( colour red) . if ok then msg "no errors
Task two
command Button Check names against a seperate list of staff who are on leave and highlight these names ( colour blue) .Staff could be ,not rostered or sick or on leave
The thinking behind each day having a separate command button to check is because the staff member is often pulled away or interrupted
Ï didnt want to go to a form , thought that was too complicated and trying to think through logically and modify what is already there
Having a hard time finding code to find and highlight cells in a column. Thought that would be easy not so
Is this realistic ? Any guidance , constructive comments would be appreciated