I have column A with 50 first names, alphabetized from A to Z. I want to be able to move my cursor to the first name in the list that begins with a specific letter.
For example: Adam, Adrian, Brian, Butch, Bob, Charlie, Chip, Chester, Dale, David. I want to move the cursor down the list until I come to the first name beginning with the letter "C", Charlie. When using "Find" in the quick access toolbar, the cursor stops at "Butch" because of the "c" in the name. I would like to have a macro so that I can select or input a letter and have the cursor move to the first name in the list beginning with that letter.
Any help or suggestions appreciated.
For example: Adam, Adrian, Brian, Butch, Bob, Charlie, Chip, Chester, Dale, David. I want to move the cursor down the list until I come to the first name beginning with the letter "C", Charlie. When using "Find" in the quick access toolbar, the cursor stops at "Butch" because of the "c" in the name. I would like to have a macro so that I can select or input a letter and have the cursor move to the first name in the list beginning with that letter.
Any help or suggestions appreciated.