grapplerca2014
New member
- Joined
- Feb 15, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hello,
I have a time sheet spreadsheet for employees
i have cell c4 allocated for user to input time sheet number ,lets say 1500
when the user goes to next time sheet in workbook i would like them not to be able to input 1500 but instead only be able to input 1501 which would be the next number in sequence. if they skip a number i would like it to show an error and if they input a used number i would like it to show an error.
currently i have a drop down list in the cell c4 and that list is taken from another page which is called rates
Is it possible to have the number 1500 deleted from the drop down list after the user has already used it so that they can not use it again and only display the next number in sequence of the last number used.
thanks for any help
mike
I have a time sheet spreadsheet for employees
i have cell c4 allocated for user to input time sheet number ,lets say 1500
when the user goes to next time sheet in workbook i would like them not to be able to input 1500 but instead only be able to input 1501 which would be the next number in sequence. if they skip a number i would like it to show an error and if they input a used number i would like it to show an error.
currently i have a drop down list in the cell c4 and that list is taken from another page which is called rates
Is it possible to have the number 1500 deleted from the drop down list after the user has already used it so that they can not use it again and only display the next number in sequence of the last number used.
thanks for any help
mike