Yes, that is true. The site Tom O suggests will show you how to do
Dependent Drop Downs.

HTH
Regards,
Howard

"Curious" wrote in message
ps.com...
Please advise on what the best strategy is for this situation:

Column A is Sales Type, Column B is Client Name

If select "New Order" in Column A, I type a new client name. If select
"Renewal Order", I want to see a list of existing clients.

The purpose is to avoid any typos so that I can use code to munipulate
the data.

Thanks in advance.