Database

  • Thread starter Thread starter ljud2
  • Start date Start date
L

ljud2

Hi I´m a new and I have a problem.
I have a customer excelsheet and a envoice excelsheet.I want to put the
information(name,address) from customer to envoice when I put the
customer number in the envoice automatic. How can I do that? thank you
fot helping. :)
 
You can use a data validation list to create a dropdown list of customer
numbers.

Then, use VLookup formulas to return the name and address for the
selected customer.

There's information on Data Validation in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

There's information on VLookup in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html

There are instructions for an order form, that uses these techniques, here:

http://www.contextures.com/xlOrderForm01.html
 
Back
Top