Have a look at the built-in DataForm for this function.

Or have a look at John Walkenbach's enhanced data form add-in

http://www.j-walk.com/ss/dataform2/index.htm


Gord Dibben MS Excel MVP

On Mon, 28 Apr 2008 11:37:01 -0700, coastal
wrote:

I need to create a data entry form in excel that will append records to a
worksheet in the same excel document. Can anyone point to a good tutorial?
I need it to work more like an Access database but the managers really want
to keep all elements in excel.