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!

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!