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? |
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? |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com