insert complete address

L

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.
 
C

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.
 
Top