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?

 

[Ajit]

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.

[email protected]

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)

 

[Amy]

Ajit,

Number of users: 5
Amount of Data: we have about 500 records now
# of fields for each record: 27

There are 2 tabs in the spreadsheet, A and B. B holds
all the data. I have created A as a "template" where
user can input data for each record. A can also be used
to update a field of each record. Hope the information
helps.

Thanks

-----Original Message-----
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.