Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD & UPDATE
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD & UPDATE
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD & UPDATE
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD & UPDATE
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD & UPDATE
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
i want to update one excel file the other one update automaticaly | New Users to Excel | |||
Update / don't update dialog box | Excel Worksheet Functions | |||
Date update on data update | Excel Programming |