View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BigPig
 
Posts: n/a
Default Can I have automatic cell population while using combo list?

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.