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.