Click on one of the letters on the left in the attached and if an entry exists beginning with that letter the whole sheet will scroll so that the top row contains the first entry with that first letter.
There are comments 'hardcoded in the code which means you need to change those lines to suit your actual circumstances.
The code is to be found in Sheet1's code-module.
|