Thanks for your advice.
Now I have another question:
I have a data list in workshet 1 like the following:

Code Session Food Price
--------------------------------
001 Breakfast Milk $2
002 Breakfast Cereal $3
003 Breakfast Bread $1
004 Lunch Vegetable $3
005 Lunch Rice $5
006 Dinner Rice $6
007 Dinner Wine $10

What I need to do is in worksheet 2, I have 4 columns have the above
headers, when the user click the cell in Session column, I need to populate
a dropdown list of the Sessions (ie Breakfast, Lunch, Dinner).
Once the user selected the session, I need to populate the dropdown list in
the Food column for the Session.
After the Food has been selected, I need to fill in the Code and the Price
cells.

So the user select the Session, then the Food and I need to find the Code
and the Price.

How do I do the Food dropdown list fill in ?
And the search of the Code and Price for a particular food ?

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Set up DV for all those cells.
>
> --
> HTH
>
> Bob Phillips
>
> "Man Utd" <[email protected]> wrote in message
> news:[email protected]...
> > This can be done at design time, because I may have 10, 20 or even 100
> cells
> > need this drop down list, how do I do that programmatically when I click
> the
> > cell in a particular column, for example, from C10 to C100, if the user
> > click these cells, the dropdownlist will appear ?
> >
> > "mangesh_yadav"
> <[email protected]>
> > wrote in message
> > news:[email protected]...
> > >
> > > One way:
> > > Select cell, go to Data > Validation. select list and then the source
> > > for the list
> > >
> > > Mangesh
> > >
> > >
> > > --
> > > mangesh_yadav
> >
> ------------------------------------------------------------------------
> > > mangesh_yadav's Profile:
> > http://www.excelforum.com/member.php...o&userid=10470
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=378908
> > >
> >
> >
>
>