Hi

You have to use dynamic named ranges as data validation lists sources (you
have to use named ranges anyway when you want to refer in data validation
list to another sheet)

Insert Name Define
AgeList=OFFSET(A!$A$1,1,,COUNTA(A!$A:$A)-1,1)
HabitList=OFFSET(A!$B$1,1,,COUNTA(A!$B:$B)-1,1)

(I assumed you have column captions in A!A1:B1 - when not, then remove -1
from formulas)

Now define your data validation lists sources as
=AgeList
or
=HabitList


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )