AutoComplete
 

Is there any way to get Excel to Autocomplete based on another sheet or
the entire Excel workbook?

I have a list that pulls from another worksheet and I would like for
the autocomplete to work!

AutoComplete
 

Nimish

Excel's autocomplete operates only on the column in which you are entering
data......and only if no blank cells to interupt the flow.

A Data Validation list cannot autocomplete either.

Use a combo box and you can enable autocomplete.

See Debra Dalgleish'a site for how-to's

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On 20 Sep 2006 15:12:15 -0700, "Nimish" wrote:

Is there any way to get Excel to Autocomplete based on another sheet or
the entire Excel workbook?

I have a list that pulls from another worksheet and I would like for
the autocomplete to work!