Entering data into a table.

[HighAndWilder]

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

 

[mumps]

Is there a way to do this without using VBA?

I don't think so.