Create a customer database with information flowing to another wor

B

Brandy

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top