tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
not sure if this is possible but i need my sheet to keep the tab and enter keys from moving data into the wrong cells
heres what i need
E8 goes to G8 goes to E11 goes to G11 goes to E14 goes to E8
p.s. The sheet is page protected and all other cells in the range of E8:G14 are locked
so basically if someone adds data into any of the above cells, it locks them into that loop, so tab or enter keys move then to the desired next cell
if they select cells outside of this range then it should just behave as normal.
not sure if this is possible but i need my sheet to keep the tab and enter keys from moving data into the wrong cells
heres what i need
E8 goes to G8 goes to E11 goes to G11 goes to E14 goes to E8
p.s. The sheet is page protected and all other cells in the range of E8:G14 are locked
so basically if someone adds data into any of the above cells, it locks them into that loop, so tab or enter keys move then to the desired next cell
if they select cells outside of this range then it should just behave as normal.