Morning all
I have a spreadsheet that has 5 columns requiring user input and after each column is a further column giving a converted figure. I need these converted figure columns locked and ideally have the cursor move to the input fields only.
So in the attached example, Coumns G,I and K are the input fields, and I need H, J, M and N locked. So the idea would be that I fill in A B C if applicable,D E F and G. Then when I hit Tab, the cursor ould move to I, then after data input and I hit Tab it would move to K and then after that move to O.
Obviously, I will still need access to the other columns at somepoint if the formulae they contain need adjusting, but as a data input, it would be really useful to be able to move as described above.
Any ideas?
Many thanks
Bookmarks