Forum Discussion
Cell Entry Required before advancing to next cell entry field
Michael1105 you have lost me. With the file I attached earlier, clear everything from B15 to O15 to get a clean starting point.
Enter something in M15. You can't. Enter a date in B15 - OK. Next cell you can enter something is C15. Try any other cell on row 15 and you can't. The only entries you can do are from the drop downs in J and O as explained earlier. And if not all cells in B15:O15 are filled, you can't enter anything in row 16.
If that's not working for you, I can't help you any further.
What I am trying to achieve is this (for example):
If a date is entered in b15, then Excel will allow for an entry to c15, and so on down the row.
If a date is entered in b15, but no entry is entered in c15, then an error message appears requiring entry to c15, (if an entry is entered in c15, but not in d15, then an error msg requiring entry to d15)...and then so on down the row.
I hope that makes sense.
The way the sheet is now, I am able to bypass entry to M15 and N15 but not able to enter in row 16 because these two cells aren't completed. That isn't going to accomplish my objective. I want to alert the user that when a date is entered then all other fields in the row are required forcing the user to make those entries.
We have a very basic log now and our branch staff aren't completing these logs in full as required by the government and the auditors. I am trying to make the log force the user into completing the necessary fields which will help us be in compliance with the two agencies.
Michael1105 you have lost me. With the file I attached earlier, clear everything from B15 to O15 to get a clean starting point.
Enter something in M15. You can't. Enter a date in B15 - OK. Next cell you can enter something is C15. Try any other cell on row 15 and you can't. The only entries you can do are from the drop downs in J and O as explained earlier. And if not all cells in B15:O15 are filled, you can't enter anything in row 16.
If that's not working for you, I can't help you any further.
I believe your solution is the best for what is needed.
Not clearing the row is what caused the confusion.
I truly appreciate you taking time out of your day to assist me.
Thank you and enjoy the rest of your day.Michael1105 You're welcome. Glad we got this sorted.