Define a name in bb.xls mylist that refers to aa.xls!aa. Then list =mylist
--
Don Guillett
SalesAid Software

"vassilis" wrote in message
...
Hi
i need some help to define a range of cells that belong into a different
book and a different sheet...
I named an area AA into a AA.xls...and i want to make this area my source
into BB.xls for my drop down list...
Thanks