insert complete address

[LouisXiX]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel In a sheet I have a database of customers (name, surname, street, city) and have another sheet where I make the invoices.
In a cell, of the sheet I make the invoice, I would like entering on a cell, the list of the addresses, make a choice of one complete address among the customers address and insert it.

 

[CyberTaz]

I believe I understand what you want to have happen, but you're looking at
it from the reverse of how Excel works Data can't be "pushed" from one
cell to another, it has to be "pulled" from the cell in which it's stored.
Have a look at the Lookup & Reference category of functions in Excel Help,
such as INDEX(), VLOOKUP(), etc. Keep in mind that each record in your main
list needs to have a unique identifier as one field of data -- such as an
account number, social security number, or something that keeps it from
being confused with another record.