Get data form ext. file when i choose an option from combo

hmoner

New Member
Joined
Nov 17, 2005
Messages
1
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.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,994
Members
412,633
Latest member
simon_elvin
Top