Hi Amy,

Excel has a built-in forms function. Put titles in row 1, and then go to
DataForm, and you will get a simple data management facility.

Add, update and delete is all catered for.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Amy" wrote in message
...
Hello.

I have recently begin to use Excel and VBA in our non-
profit organization. Would like to ask for help in this
community.

I am using Excel as a Contact Management. There are 2
worksheets, A and B. B holds all the data while A allows
a user to:

* add a new record
or
* to update an existing record

Could someone direct me what kind of code to program for
the above 2 functions?