How to automatically jump to another cell after input data?

Question

I'm entering data in column A (going down after pressing enter). So I filled A1, A2,A3, A4....A60. After pressing enter in A60, I want the cursor to position automatically itself in cell C1. It will continue jumping from one column to another after I enter 60 values in per column (columns E, G, I). The simple fact is that I don't want to use the mouse or the arrows to position the cursor at the beginning of the next column that I need to fill. How can I achieve this using VBA?

Thanks.

Answer 1

Hola Vladimir

Please try this method before go into VBA.

1- Select rows from 1 to 60

2-Go to Format cell > Protection and Unlock cells (uncheck)

3 - Go to Review > Protect Sheet > Select unlocked cells only

Password is Optional

This will lock all the cells above row 60 so when you reach that row from any column It will jump to the top of the next column (B1,C1,D1.....)

Do let me know if you require any further help on this. Will be glad to help you.

Please Note:

By marking a Reply as a "Accept as Solution", if it solves your problem. Will give positive reinforcement, not only to the person who responded, but also will help other users with the same or a similar question by directing them to the response.Thanks for your co-operation.

Regards

Jeovany CV

Answer 2

Thank you. It works.

However, now that you respond to me, I realize the following situation. The columns that I need to fill with this process start at row 18. Before that row there are some information that I need to fill too (so I can't lock the cells). After I fill this info is when I move to the columns where I initiate automatic process. For example, when I press enter in A60, the cursor goes the first row that is unlocked in column B (which is B6 but I put there another information not related to what the columns have) and I need the cursor to go specifically to B18.  This file is going to be used by other people, so I can't give them the password to protect and unprotect the worksheet.

Regards

Answer 3

You must follow the same process from my post but this time select rows from 8 to 60.

Regarding the other cells with info above row 8. You can do the same by selecting them individually.

To move across unlocked cells press Tab or the arrow keys as well as the Enter key.

Hope this answer your question.