Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a customer database with information flowing to another wor
Please tell me if this is possible:
I need to create a customer database that can be continually updated with new information. With that information, I would like to be able to access a particular customer on another worksheet form. Is that possible in excel? I can create a database with no problem but I am having problems on figuring out to have the database information appear on one form. Thanks! brandy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a customer database with information flowing to another wor
Brandy
Have you tried VLookup? That is a formula that you can place in each of the cells in the other worksheet form and that formula will pull in data from the database. Look it up in Help. Come back with more layout detail if this doesn't work for you. HTH Otto "Brandy" wrote in message ... Please tell me if this is possible: I need to create a customer database that can be continually updated with new information. With that information, I would like to be able to access a particular customer on another worksheet form. Is that possible in excel? I can create a database with no problem but I am having problems on figuring out to have the database information appear on one form. Thanks! brandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database to Find customer by zip code | Excel Discussion (Misc queries) | |||
customer database for mailings and invoice analysis | Excel Discussion (Misc queries) | |||
How can I create a customer database to use with an invoice? | Excel Worksheet Functions | |||
Customer Quoting Database | Excel Discussion (Misc queries) | |||
How do I create a customer database in excel | Excel Discussion (Misc queries) |