You can use Data Validation to create dropdown lists of options. There
are instructions in Excel's Help, and he

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

It would be easiest to just have a master list, and keep all the
information on one sheet. Then, use filters or pivot tables to view the
data for one or more names. There's information on both topics in
Excel's Help, and he

http://www.contextures.com/xlautofilter01.html
http://peltiertech.com/Excel/Pivots/pivotstart.htm


Kelly wrote:
Okay I am new to excell bar drawing little spreadsheets to do my own financing.
I am currently setting up a sheet and need the users to be able to select
from a list of options only and not input thier own text - does that make
sense?
also i ahve 12 names on the list and one master with all on - would like the
data entered on to a names list to be automatically entered onto the master
or vice versa which ever is easiest.
sorry if this sounds jumbled but i am totally lost and this has to look
really hot for work!

regards

Kelly - England



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