formula based on three dependent drop down lists

[HansV]

Ah, I see what I did wrong. I cleared the Change_History sheet, and in doing so, removed the defined name Start_Cell. My apologies.

Please select cell B6 on Change_History and name it Start_Cell. Then save the workbook, close it and reopen it.

[DVM]

Tha's perfect, but why do I have to click a cell twice to tab to the next one in the row.
Thanks a lot. Best regards DVM

[HansV]

That doesn't happen to me.

[DVM]

May I please confirm with you if you have entered some data in I5, J5, K5

[HansV]

No, I had concentrated on columns D, E and F because almost all your previous questions were about those columns.

The behavior that you experience is an inevitable side effect of the code - you use Application.Undo to retrieve the previous value of the cell being changed. The Undo also cancels the move to another cell, whether to the right / left (with Tab / Shift Tab) or down / up (with Enter / Shift Enter).

[DVM]

Thats a great job done. Thank you so much!