Help with a database..
 

Hi, I hope that someone can help me I am trying to figure out how to make a
address database with account numbers for my customers, I have all my
Address and account numbers in one worksheet an then on the front worksheet I
would like to be able to find a customer in the database without having to
search through rows and rows of information and have it list all the
information in a list form and I would also like to be able to input new
customers from the front page and have it go to the database, does that make
sense? if not please email me and I will send you a copy of the database
that I have started and how I would like the front page to look I only know
very basic info on excel. Thanks for any help..... (knmcferron (at) alltel
(dot) net)

Help with a database..
 

Maybe the best shot is to combine a DROPDOWN LIST with VLOOKUP

"got2stamp" wrote:

Hi, I hope that someone can help me I am trying to figure out how to make a
address database with account numbers for my customers, I have all my
Address and account numbers in one worksheet an then on the front worksheet I
would like to be able to find a customer in the database without having to
search through rows and rows of information and have it list all the
information in a list form and I would also like to be able to input new
customers from the front page and have it go to the database, does that make
sense? if not please email me and I will send you a copy of the database
that I have started and how I would like the front page to look I only know
very basic info on excel. Thanks for any help..... (knmcferron (at) alltel
(dot) net)