have a list of name and from cell a1 input the first letter and have cursor move to the cell that start with that name

Calc, 4.3.0.4, english, windows XP

Could you please describe in more details what do you want to achieve?

I have a list of names in a col. What I would like to do in cell a2 to be able to type just the first letter of one of the names in the col and have the cursor move to that cell that has name in it.

If I understand what you are trying to do correctly, I don’t know if there is a simple way to do it.

However, you could put a text box on the spreadsheet. Then you could assign a macro to the “Text modified” event that would search for the text in the list of names and move the cursor to the appropriate cell.

Again, it is not a very simple solution.