Hey "BigPig",
you're right, and thanks ! the trick was to enter enough numbers the first
six haracters are all the same alpha/numeric pattern when I entered the
seventh number (one at the bottom of the list) it auto filled. Now I can use
the scroll or let it auto fill.

Thanks again
l
"BigPig" wrote:

Hi rick,

Sorry, I reread what you wrote, and I think I understand.

You could just start typing in the 'combo list', and it should auto fill.

"rick" wrote:

Big Pig
Thank you for your response. I want to either scroll up and down or enter
the information in the cell in the event the item I want is way down the
list. Can I do this?

"BigPig" wrote:

Hi rick,

If your 'combo list' is a drop down, you could use index and match to pull
up data to populate your other cells. That is, assuming that you are pulling
from a database of sorts that is sorted.

"rick" wrote:

How do I get my combo list to populate the cell without scrolling up and
down? I am planning to have many items and I was hoping that in addition to
using the list I would also be able populate the cell with partial input.