Client ID on one worksheet transferred to another worksheet

[Guest]

The client IDs are alphabetically on one worksheet listed vertical. I want to
be able to type an alphabetically letter in the cell on the new worksheet and
for excel to give me a list of the client's IDs starting with that letter
from which I could possible select from.

Is this possible?

Thanks in advance for the help. You all are doing a great job with
volunteering your time and the assistance you provide. Very much appreciated.

Marty

 

[Roger Govier]

Hi
Take a look at Data Validation on Debra Dalgleish's site

http://www.contextures.com/xlDataVal01.html
If you want to be able to type a single letter and jump to that part of
the List, there is a download file with methods of achieving this
http://www.contextures.com/DataValHeadings.zip

Having made your selection, you can use Vlookup to populate other cells
with Address etc.
Debra has help on this function at
http://www.contextures.com/xlFunctions02.html

 

[Guest]

Question - Why don't you give yourself credit on the website or did I miss
it? You did write the macros didn't you?

 

[Roger Govier]

Hi Shane

For the downloadable zip file I mentioned, yes I did write the code, and
there is a rem statement in each sub to say this.

On Debra's site, in the Sample file's section, there is a short
descriptive paragraph which says the file is from me.
That is the total extent of what I wished Debra to say, when she kindly
agreed to make this available through her site, me being far too lazy to
create and maintain a site of my own<bg>

 

[Guest]

Hi,

Roger's code does a nice job with your problem. Let me say I have seen
another code example which lets you continue to type and pare down the list,
which means that when you type B you get a list of all B's, then you continue
by typing "a" the list pares down to all Ba's and so on. Unfortunately I
don't know where I saw it.

This ability to pick from a list by typing letters is also available for the
Combo Box control on the Control Toolbox toolbar. In that case as you type
it displays the first entry that has the letters you have typed and you don't
need to open the drop down to use the feature.