ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   customer database (https://www.excelbanter.com/excel-programming/337280-customer-database.html)

Randy C via OfficeKB.com

customer database
 
I am wondering if there is a way to create a customer database that has
addresses in it, so when I enter information in to an electronic job ticket
the info pops up with the customer info?

Thanks

Tom Ogilvy

customer database
 
Just type the information in a table and use Vlookup worksheet function to
retrieve it. See the help on Vlookup in Excel.

--
Regards,
Tom Ogilvy


"Randy C via OfficeKB.com" wrote in message
...
I am wondering if there is a way to create a customer database that has
addresses in it, so when I enter information in to an electronic job

ticket
the info pops up with the customer info?

Thanks





All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com