ADD & UPDATE

[Amy]

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?

 

[Guest]

There could be couple of ways to achieve this but i could not gather enough information from your question. Write some details and i dont think it is gonna be tough.

Also answer some questions like : Number of users, Amount of data. Any report printing from that data , How many fields for a particular record etc.

 

[Tom Ogilvy]

send me a sample workbook and I will work something up for you.

(e-mail address removed)

Don't send a big one - just a sample - worksheet A complete, some sample
data in B.

Include a good return address or I won't be able to return it to you.

 

[Bob Phillips]

Hi Amy,

Excel has a built-in forms function. Put titles in row 1, and then go to
Data>Form, 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)