Newbie Question - can you create a database to pull info into a form?

[Guest]

Is there a way to create an Excel database to input
information and then pull info into a form? We need to have 3
diferent forms that info could be pulled from a database so that the
forms don't need to be handwritten or typed each time. I'm willing to
do the research needed to do this if it is possible. Info would
change, and not all fields would be pulled into each form. I hope
this makes some sense. Thanks.

 

[Gord Dibben]

Set up your database in columnar format so's you can use VLOOKUP formulas in
your 3 forms to pull data based upon criteria.

Good place to start for info is Debra Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP