Inserting contact details from another sheet

**maff** · 10-15-2008, 08:59 AM

Hi!

I have a workbook which I use for invoicing customers. Sheet one is the inovice template. Sheet two is the contact details of all my clients (i.e. column headings are Name, Address 1, Address 2, Town/City etc.).

In the invoice sheet I would like to be able to select the name of the client from a dropdown so that it automatically fills in the address into the other cells of the invoice.

How can I do this?

Cheers in advance!!!!!

**royUK** · 10-15-2008, 09:04 AM

Use Data Validation to create the drop down ( see http://www.excel-it.com/data_validation.htm) and VLOOKUP based on the selection to get the data (see-http://www.excel-it.com/excel_functions.htm)

**maff** · 10-15-2008, 09:21 AM

Cheers for the ultra quick reply Roy! These look like they're just about the right thing: just one thing though... in Data Validation if I try to reference another worksheet it says you can't use other sheets for data validation.

Any other ideas?
Cheers!