Jimmy,
Forgive the question, but why do you need a dropdown? Why not use columns
and rows, different attributes (IS System, SP, etc) in columns, names down
the rows). Then fill in the grid. You could then apply filters to all
columns so you could see everyone on XP, with SP2, etc.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jimmy" wrote in message
...
Hi, I need to display computer info (name, OS System, Service pack,
Software
etc.) for 14 users in MS Excel (XP). I was thinking instead of using 14
worksheets (one for each user) i could display all the info on a worksheet
using a dropdown and replacing data according to the username. Is this
possible? and how, so that i can look into it. I do have some VB
knowledge.