Hello,

Say, I have column called "Employee Designation" in a excel 2k
spreadsheet. This spreadsheet kind of plays the role of a simple form.

Everytime a user updates the spread sheet for a new row, I want the
cell under "Employee Designation" column to appear as a drop down
list.

In fact, whevever a user has to choose between a fixed set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.

Hi
as a starting point:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


ssb wrote:
Hello,

Say, I have column called "Employee Designation" in a excel 2k
spreadsheet. This spreadsheet kind of plays the role of a simple
form.

Everytime a user updates the spread sheet for a new row, I want the
cell under "Employee Designation" column to appear as a drop down
list.

In fact, whevever a user has to choose between a fixed set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.

Try using Data Validation. Go to Data / Validation... In
the Allow box select List, then in the Source field
indentify the range on your worksheet which contains the
lookup values. Only limitation is that your lookup values
have to stored on the same sheet.

Manuel
-----Original Message-----
Hello,

Say, I have column called "Employee Designation" in a
excel 2k
spreadsheet. This spreadsheet kind of plays the role of a
simple form.

Everytime a user updates the spread sheet for a new row,
I want the
cell under "Employee Designation" column to appear as a
drop down
list.

In fact, whevever a user has to choose between a fixed
set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.
.

You can use a list from a different sheet if the list is a named range.
There are instructions he

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


Manuel wrote:
Try using Data Validation. Go to Data / Validation... In
the Allow box select List, then in the Source field
indentify the range on your worksheet which contains the
lookup values. Only limitation is that your lookup values
have to stored on the same sheet.

Manuel

-----Original Message-----
Hello,

Say, I have column called "Employee Designation" in a

excel 2k

spreadsheet. This spreadsheet kind of plays the role of a

simple form.

Everytime a user updates the spread sheet for a new row,

I want the

cell under "Employee Designation" column to appear as a

drop down

list.

In fact, whevever a user has to choose between a fixed

set of values

for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.
.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"Frank Kabel" wrote in message ...
Hi
as a starting point:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


ssb wrote:
Hello,

Say, I have column called "Employee Designation" in a excel 2k
spreadsheet. This spreadsheet kind of plays the role of a simple
form.

Everytime a user updates the spread sheet for a new row, I want the
cell under "Employee Designation" column to appear as a drop down
list.

In fact, whevever a user has to choose between a fixed set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.


This site appears to be nice.......Thanks.....