drop down lists

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I am working with a physician that is keeping track of HIV
patients in an Excel workbook. Can a column be set up so
that it has a drop-down list that will show different
types of immunizations her patients would receive? She is
also wanting to insert the date of the immunization in the
same cell. Is that possible? If so, how do I set this
up? Thanks!
 
I think the easiest thing to try is Data|Validation.

Debra Dalgleish has tons of tips at:
http://www.contextures.com/xlDataVal01.html

And tell the doc that she would be better off putting that date in an adjacent
cell. It'll make life a lot easier later on if you ever want to do something
with it.

In fact, as a general rule, I find it better to put each field into a separate
column. It's lots easier to combine a couple of cells than to try to separate
it out later.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data valiation, dropdown list question 2
Filtered drop down list 2
Data Validation, drop list question 1
Adding more options in a drop down list 4
Excel Drop Down List 4
Excel Excel: How do I put a formula in a drop down list 11
Creating a Report 1
Using drop down lists 2

Back
Top