Can someone help me with the drop down list. I saw an example on excel help
but it is not working for me. Really different from Access. I have four
choices I would lke to have people choose from.

On-Track
At-Risk
Concerns
Decision Required

Can someone help me with creating the list.

Put the four value in a column (say A1 to A4) and name the list e.g. name is
"myname"

Insert==Name==Define==='myname' no quotes))

Then select cell for your drop down list, then do:

Data==Validation==Allow-list==Source "=myname" (no quotes)

HTH

"Sher" wrote:

Can someone help me with the drop down list. I saw an example on excel help
but it is not working for me. Really different from Access. I have four
choices I would lke to have people choose from.

On-Track
At-Risk
Concerns
Decision Required

Can someone help me with creating the list.