Hi guys
I was requested to get a list of clients from external xls file... I did this:

1) Open 2 files, clients.xls and receipts.xls
2) in receipts.xls, any cell, put =, then go to clients.xls and select all the clients in a range, and press enter
3) copy the formula generated in the cell, then go to name, define, put a name, for example clientslist, paste formula, add and press ok.
4) now go to Data>>Validate, allow list, source, and put this: =clientslist

This worked great, In receipts.xls, I get the clients list from clients.xls but now:

How could I do to:

If user chooses a client, to put his age, phone, etc. in adjacent cells automatically...

note: Clients are listed as: code, name, phone, age, etc. in clients.xls

Thanks a lot in advance. Hope your help.