Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Records
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Records
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check and Remove Records | Excel Discussion (Misc queries) | |||
Display 10 records from same workbook but from different sheet | Excel Worksheet Functions | |||
Top 90% of records - Bring out number | Excel Discussion (Misc queries) | |||
display set of records in a form with previous and next button | New Users to Excel | |||
Deleting specific records | Excel Discussion (Misc queries) |