| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drop down lists
thanks to some members of the forum i now have drop down lists on my spreadsheet, however... i have to input say 20 peoples information in a month and i was woundering if i could set it up so that i can use the one drop down list to deal with all 20 peopels, so for example.. person 1 wants 'shoes', click cell a2, click on shoes from table and it is inputed. person 2 wants 'hats', click cell a3, click on shoes from table and its inputed. etc at present i can only control one cell, with one drop down list, can a condition on something be places so that i can save my spreadsheet from haveing 20 different drop dpwn lists. thanks john to the members of the forum whom answered me firsted, thanks :) -- johnny.exe ------------------------------------------------------------------------ johnny.exe's Profile: http://www.excelforum.com/member.php...o&userid=30775 View this thread: http://www.excelforum.com/showthread...hreadid=518723 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Lists | Excel Worksheet Functions | |||
| Drop Down lists | Excel Discussion (Misc queries) | |||
| unrestricting drop down lists | Excel Worksheet Functions | |||
| Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
| Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
Threaded Mode
