Data Validation in Excel 2002

  • Thread starter Thread starter geoff_francis_cox
  • Start date Start date
G

geoff_francis_cox

Hi

I want to limit the content of a cell based on what is entered in another
cell. For example if I enter "John" in cell A1 then in A2 I only want to be
able to choose from "Smith" or "Jones". But if I enter "Mary" into cell A1
then in cell A2 I only want to be able to choose "Jackson", "Bush" or
"McKenzie".

Is there a way I can do this in Excel 2002 (XP) using a macro or some sort
of VBA code?

Hope someone out there can help. Thanks in advance.
 
Debra

That's brilliant and so easy (when you know how).

Thank you so much.

Geoff
 
Back
Top