Client ID on one worksheet transferred to another worksheet

M

mda19652

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
 
S

ShaneDevenshire

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

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>
 
S

ShaneDevenshire

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.
 
Top