HighAndWilder
Well-known Member
- Joined
- Nov 4, 2006
- Messages
- 712
- Office Version
- 365
- Platform
- Windows
I have a nine column table which the user enters data into.
Only data is entered into columns 2 and 8, the rest are formula which use the XLOOKUP function onto another table.
Data is numeric and the number pad on the keyboard is used to enter this data.
I would like the user to enter the data into column 2, press Enter and active cell move to column 8 to enter the second value.
Pressing Enter is to then take the user to column 2 in a new row.
Is there a way to do this without using VBA?
Thanks
Only data is entered into columns 2 and 8, the rest are formula which use the XLOOKUP function onto another table.
Data is numeric and the number pad on the keyboard is used to enter this data.
I would like the user to enter the data into column 2, press Enter and active cell move to column 8 to enter the second value.
Pressing Enter is to then take the user to column 2 in a new row.
Is there a way to do this without using VBA?
Thanks