Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Am I in the right place?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Am I in the right place?
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Am I in the right place?
Putting it on separate sheets would make it extremely hard to work with.
Better to set up a database on a single sheet. You could then have a dropdown on another sheet and use vlookup to populate additional information. -- Regards, Tom Ogilvy "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I keep a tab in place? | Excel Discussion (Misc queries) | |||
Fun Place | Excel Worksheet Functions | |||
No place for sum | Excel Worksheet Functions | |||
This place ROX!! | Excel Discussion (Misc queries) | |||
1st, 2nd, 3rd Place etc..... | Excel Worksheet Functions |