Cell Validation Based On Multiple Lists

[fatdaz]

Hi Folks

I want to validate the data input in a given cell based on 3 separat
lists. I am trying to get a dropdown box to show all items in the
lists as 1 amalgamated list. How do I do this (Excel 2003)

Cheer

 

[Debra Dalgleish]

There's a sample file on my web site that combines three lists into one:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Combine Multiple Lists into One'