In essence you have a database and an entry form.

One way to handle this is to limit your entry form to a small range:

On the Entry form sheet:
A1:name,
B1: address,
C1:ssn,
etc...

A2 to G2 are the user entry cells

In your auto_open routine, use the following code to restrict the user
to only these cells:
Sheets("DataEntry").scrollarea="A2:G2"

On this sheet, have a command button that will copy these cells to the
next blank row of your database.

When you want to "Extract" records from your database, use autofilter
or advanced filter to "view" the records of interest or to copy them to
a third sheet where you can view and edit them or format them to fit
your desired "Report"


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements