Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kim
 
Posts: n/a
Default Making a drop down list/column

Hi there.
I am trying to make a cell into a drop down list. I am trying to make a data
base that I can use for my FRG, and some of the functions I need to be able
to have is multiple children & their birthdates, but I don't want to take up
a ton of space, so I figuered if I could use a drop down, I could just add
them in their and when I needed to access that info, I could just "drop it
down".
Any assistance with this is greatly appreciated!
--
Thanks so much!
~ Kim
  #2   Report Post  
Max
 
Posts: n/a
Default

Try Debra Dalgleish's nice coverage of Data Validation at:
http://www.contextures.com/xlDataVal01.html

And a dynamic range could also be used in the DV
Try Debra's "Create a Dynamic Range" at:
http://www.contextures.com/xlNames01.html#Dynamic

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kim" wrote in message
...
Hi there.
I am trying to make a cell into a drop down list. I am trying to make a

data
base that I can use for my FRG, and some of the functions I need to be

able
to have is multiple children & their birthdates, but I don't want to take

up
a ton of space, so I figuered if I could use a drop down, I could just add
them in their and when I needed to access that info, I could just "drop it
down".
Any assistance with this is greatly appreciated!
--
Thanks so much!
~ Kim



Reply
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
can you make a drop down list in a drop down list? Sburlingham Excel Discussion (Misc queries) 18 October 12th 09 07:58 AM
formulas for drop down menus Char Excel Discussion (Misc queries) 0 July 18th 05 07:29 PM
Copy drop down boxes and associate to cells dynamically in excel t Killion Excel Worksheet Functions 2 June 10th 05 03:11 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 11:42 AM


All times are GMT +1. The time now is 05:48 PM.

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

About Us

"It's about Microsoft Excel"