I need blank drop down list in all cell of a column in a particular range,
which I can get by selecting a blank range. But what I need is that whenever
I enter any word into cell, the drop down list should except that word and
make that word a part of drop down list. For example if I choose blank range
for drop down list it will show nothing but if I enter manually (1) Ar then
(2) Billing it should show these two words.

You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0012 - Update Validation List'

jai wrote:
I need blank drop down list in all cell of a column in a particular range,
which I can get by selecting a blank range. But what I need is that whenever
I enter any word into cell, the drop down list should except that word and
make that word a part of drop down list. For example if I choose blank range
for drop down list it will show nothing but if I enter manually (1) Ar then
(2) Billing it should show these two words.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Just one caveat.

You cannot start with a completely blank list.

You must have something in A1 of the "Lists" sheet.

A <space will do.


Gord Dibben MS Excel MVP

On Fri, 01 Feb 2008 15:53:24 -0500, Debra Dalgleish
wrote:

You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0012 - Update Validation List'

jai wrote:
I need blank drop down list in all cell of a column in a particular range,
which I can get by selecting a blank range. But what I need is that whenever
I enter any word into cell, the drop down list should except that word and
make that word a part of drop down list. For example if I choose blank range
for drop down list it will show nothing but if I enter manually (1) Ar then
(2) Billing it should show these two words.