LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to make a column of cells have a drop down menu

On one sheet, I would like to have a list of names (travelers in my case)
which I would assume I would need to define as a group. I would like the
first column of cells on ANOTHER sheet in the workbook to each have a drop
down menu when clicked upon, that lists every name (from the previous sheet)
so that you can choose which name to put in the cell. Is this possible in
Excel? In the end, I basically would want one sheet to store all the names,
then as many sheets as needed for different projects where I could just draw
upon those names with drop down menus.
Thanks for any help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i make a packing slip with a drop down menu tmwinte Excel Worksheet Functions 1 July 9th 07 08:30 PM
how do i make a packing slip with a drop down menu tmwinte Excel Worksheet Functions 0 July 9th 07 08:24 PM
One value gives different drop menu in next column Marlene Excel Discussion (Misc queries) 1 June 18th 07 11:35 AM
How to make drop-down menu of months in schedule,when сhoose it - columnes are added? Huawei Excel Discussion (Misc queries) 0 January 13th 06 04:01 AM
How to make drop-down menu of months in schedule,when сhoose it - columnes are added? Huawei Excel Worksheet Functions 0 January 11th 06 04:44 AM


All times are GMT +1. The time now is 03:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"