How to add data to drop down box ?

**Soon Swee Fong** · 10-17-2012, 11:08 PM

Hi, I am new here, can anyone help me to solve my problem as file attached :
(to add data to a drop down box):

Thanks a lot !

**FDibbins** · 10-17-2012, 11:30 PM

im not understanding why you would use the "query" data for the drop-down, and then want to put dates in instead? why not just use the dates as the drop-down instead? you have only set DV for the 1st cell in that range tho?

maybe if you could explain more what you are trying to do, and what you want as a result?

**Soon Swee Fong** · 10-18-2012, 12:18 AM

Hi,

Attached again the file in more details.

There may be few requirements for 1 case and one requirement may issue few reminders. So, i have to key in the date when I issue query and reminders.

Please help. Thank you.

**FDibbins** · 10-18-2012, 12:57 AM

as far as i can tell, all you have done is add 2 more columns for "status" this still doesnt explain to me what you are to achieve?

you have this for your data validation (drop-down)...
Query
1st reminder
2nd reminder
3rd reminder
4th reminder
5th reminder
what else do you want to show in H, J or L?

**Soon Swee Fong** · 10-18-2012, 05:08 AM

Hi,

Actually what I want is in a cell, i can key in some information as following :

Type Date Action taken
Query 01/01/2011 informed immediately
1st reminder 01/06/2012 letter sent
2nd reminder xxxxxxxx xxxxxxx
3rd reminder
4th reminder
5th reminder

The reason why i don't want the information shows in other cell / colum / row is because there will be repeating recording in the next column, I try to make the worksheet simple and easy to read.