want a list of selectable names on my worksheet

G

Guest

Hi

You could use Data/Validation/List. Prepare your list in another sheet and
point your validation at the list.

Hope this helps.
Andy.
 
B

Boze

I'd like to have a list box with employees names on my worksheet that has
per diem calculations. I've found the Forms toolbar and put the listbox on
the worksheet but I haven't figured out how I should input the names so they
show in the list AND then how to select a name from the list. Or maybe a
list box isn't what I should use for what I want to do? I would only need
to select one name at a time. Would appreciate any help.

Thanks
Boze
 
S

starguy

you should use data validation
first select the range of cells where you want to apply the list bo
options to select the data from drop down list.
then go to Data > Validation under setting tab > Allow (select List)
then in source put the range of cells where list of employees' names i
(you must have list of employee names in your worksheet or workbook)
it is better to give Name to your employees' names list. you can d
this by going to Insert > Name > Define (type "employees" withou
quotes and in refers to select range where employees name resides an
press Ok)
now in data validation under setting tab > Allow (select List), then i
source put =employees and ok.
now when you select the cell on which you have applied data validatio
to put the data, a drop down button will appear, you can select any o
employee name from that list.

hope this would help you.
 
B

Boze

That worked perfectly! What I've got now is a list from which I can select
an employee which is great. I can make a second list where I can select
their postion such as Salesman, VP, Toolmaker which is the other piece of
info I need to display. Is there a way to have ONE list selection that
would put info in 2 cells? Ie, "John" would go in the column under 'Name'
and "Salesman" would go in a column under 'Position'. Seems like a pipe
dream but just wanted to check.

Thanks again for the help with the first list. That's the main thing I
wanted to get setup.
 
Top