Hello:

I have a problem to which I'm sure there is a solution, but I haven't been
able to find it yet:

I have a master list of different employees' ratings (and the number of
evaluations they have received) toward the bottom of my worksheet. At the
top of this worksheet, I have a table listing the employee's name, # of
ratings, and averaged rating. Underneath that column, I have the workplace
average, total number of workplace ratings for all employees and the averaged
rating for all. Underneath that, I have a graph showing the range of
ratings, then the marked all employee average and "your" rating shown. All
of the total employees data and graph are self-populated, based on values in
the summary tables (which pull the correct values from the master table at
the bottom (3 columns: employee, # of ratings, average rating), and the table
automatically updates each individual's values and graph ONCE that
individual's name is typed into the "employee name" box. (the summary table
and ratings graph are then emailed to the employees, so they know where they
stand compared to the group as a whole)

Now, because all the employee's data is pulled with a "match" function, the
rating and # of ratings are pulled based on the way the employee's name is
typed. To save time typing (as there is a very large list of employees) and
also to eliminate any errors, is there a way to either create a drop-down
list of employee names to select, -OR- a way to make the employee names in
the master list "clickable" so once they are clicked, the name automatically
appears in the appropriate "employee name" in the summary box at top? (the
master list is continually updated and may not be in the same order all of
the time, as it's copied from another list, so the drop down, based on teh
values in the master list may be better). I've tried the "filter" function,
but it only wants to filter waht is immediately below (i.e., employee name
adn "all employee average" and I can't seem to make it pick a range to
filter, PLUS i don't want the arrows showing up, when the box is
copy/pasted).

Thanks for your advice

Hi Bernie,

If you apply Data-Validation to your employee name cell, you can choose a
list range and it will provide a drop-down box as you describe.




"Bermie" wrote in message
...
Hello:

I have a problem to which I'm sure there is a solution, but I haven't been
able to find it yet:

I have a master list of different employees' ratings (and the number of
evaluations they have received) toward the bottom of my worksheet. At the
top of this worksheet, I have a table listing the employee's name, # of
ratings, and averaged rating. Underneath that column, I have the
workplace
average, total number of workplace ratings for all employees and the
averaged
rating for all. Underneath that, I have a graph showing the range of
ratings, then the marked all employee average and "your" rating shown.
All
of the total employees data and graph are self-populated, based on values
in
the summary tables (which pull the correct values from the master table at
the bottom (3 columns: employee, # of ratings, average rating), and the
table
automatically updates each individual's values and graph ONCE that
individual's name is typed into the "employee name" box. (the summary
table
and ratings graph are then emailed to the employees, so they know where
they
stand compared to the group as a whole)

Now, because all the employee's data is pulled with a "match" function,
the
rating and # of ratings are pulled based on the way the employee's name is
typed. To save time typing (as there is a very large list of employees)
and
also to eliminate any errors, is there a way to either create a drop-down
list of employee names to select, -OR- a way to make the employee names in
the master list "clickable" so once they are clicked, the name
automatically
appears in the appropriate "employee name" in the summary box at top?
(the
master list is continually updated and may not be in the same order all of
the time, as it's copied from another list, so the drop down, based on teh
values in the master list may be better). I've tried the "filter"
function,
but it only wants to filter waht is immediately below (i.e., employee name
adn "all employee average" and I can't seem to make it pick a range to
filter, PLUS i don't want the arrows showing up, when the box is
copy/pasted).

Thanks for your advice