Hi
I have a sheet for Work In Progress stocktaking. The sheet is protected except for cells in which order number are typed.
Using ENTER or TAB brings you down to the next cell for typing, in between typing cells are 10 rows with lots of lookup (Index,Match).
Problem is reaching bottom row on screen, rows that are not on screen and rolled up when doing a ENTER, showing no data until a PAGE UP and PAGE DOWN are done.
Hope it’s possible to understand.
I have a sheet for Work In Progress stocktaking. The sheet is protected except for cells in which order number are typed.
Using ENTER or TAB brings you down to the next cell for typing, in between typing cells are 10 rows with lots of lookup (Index,Match).
Problem is reaching bottom row on screen, rows that are not on screen and rolled up when doing a ENTER, showing no data until a PAGE UP and PAGE DOWN are done.
Hope it’s possible to understand.