Forum Discussion

Michael1105's avatar
Michael1105
Brass Contributor
Feb 23, 2023
Solved

Cell Entry Required before advancing to next cell entry field

Hello my most valued asset, Excel Community, I am forever grateful to all of you who have assisted me in the hurdles I've had to cross with Excel. I am reaching out to you again with hopes that som...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 24, 2023

    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 24, 2023

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.

Michael1105's avatar
Michael1105
Brass Contributor
Feb 24, 2023

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.

Resources