you can have the workbooks do a VLOOKUP, but it depends on where you're
putting the info. If the data you have is in one row, you can have your new
workbook look up the customer name and provide data from any other column.
=VLOOKUP(name,range to look in,column to return data from,False) makes sure
you only get an address if there's a match.

"Christine" wrote:

I have a form that I use as an invoice for ordering products. I enter a
customer name along with address and phone number. Is it possible that when I
enter the customer information it can automatically be saved to another
worksheet for future orders where I can enter the name and the shipping
information automatically shows up?