There's an example here that combines three named ranges, using formulas:

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

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

There are instructions here for creating named ranges:

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

Nir wrote:
Hi,
How can that be done?
I have 3 different lists in 3 different sheets.
I want to create ONE list from all 3 and present it with validation list in
sheet4.

Please assist


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html