Maybe you want something like this:
http://contextures.com/xlForm02.html
From Debra Dalgleish's site.

kyoshirou wrote:

if i entered some values at some columns, these values are not inside the
database, is it possible to so-called auto-create into the database?
is macro required?

A B C D
1 1 1 1

If these values are not found in sheet 2(i rename as "data"), it will auto
capture and save inside sheet data.
Maybe there's a button called "Capture" ?

Regards,
kyo

--

Dave Peterson