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!