Find Jobs
Hire Freelancers

Contact management system in EXCEL- Knowledge of *EXCEL FORMS* is Important!

$30-250 USD

В роботі
Опублікований almost 10 years ago

$30-250 USD

Оплачується при отриманні
I need to create a contact management system in excel. I attend a lot of meetings and meet a lot of different people and i want to keep everything up to date in an excel file. I want the database to be easily updated and added to. This means i want to create forms where i can easily enter in the information. I have already started most of the work and have included examples of what i want in the attachments. Please look at the attachments to understand what i am trying to do. 1. Enter Contact information of the people i meet with 2. Enter Meeting information about the people i meet with 3. Filter this information and create reports from it 4. Be able to export the filtered information I have included all the current criteria i can think of however, i would like to leave some spaces open so in the future if i think of additional criteria i can add to the forms and the database. Also i need to be able to add other places in addition to the spaces left open. I want the forms to prompt for an entry based upon the first 3 letters of what i type. For example, if i already have the company 'General Electric' input from a previous meeting, when i begin typing 'Gen', it will prompt me to fill it with 'General Electric' Also, for the meeting section, if i already have the contact in the database, it will populate their information once i enter in their name. if i don't have them in the contact section, there will be a spot on the ' Add Meeting' form where i can click to go to the 'Add contact form'. Once i have added the contact information and meeting information (which will include notes on the meeting) i want to be able to create a report from certain criteria i choose (i.e. create a report about all the meetings i have had with 'Bob Smith'). I should be able to export this to word or print it easily straight from excel. I also want to be able to export to a new excel file, several different peoples contact information based upon certain criteria. For example, i would filter based upon company, an event, or a time period. From that filter i need to export those contacts to a new excel file. Additional issues you need to be mindful of: 1. There may be several representatives from one company who attend a meeting. 2. I need an easy way to update the contact information (for example if someone switches jobs). 3. I need a way to easily delete a contact/ email address. For example, search for the email address and once it finds that person, there is a button to delete that contact. 4. I want to be able to automatically save the file with today's date and if it has already been saved once today to add increasing values for version for example 'ver. 1' then 'ver. 2' then 'ver. 3' etc. 5. I want a way to save your input while you are putting stuff in the form? 6. I want a way to reopen a form once you have already submitted it and continue to add data into it? 7. I want a button to export the data of a contact/meeting 8. I want a button to import the data of a contact/meeting which was previously exported The files i have attached: Form [login to view URL] This form IS NOT COMPLETE. This is just an example of what i want it to look like. It needs to be cleaned up and make sure to include all the criteria in the form and link it to the database. Attached: Finished Product [login to view URL] This is similar to what i eventually want it to look like. There should be forms and buttons and a master database and output to reports which can also be exported. Attached: [login to view URL] This is some of the criteria i want to you. Please also include blank spaces and a way to add to this criteria in the future. Please contact me if you have any questions and keep me updated on your progress by sending me the file you are creating so i can tell you if you are on the correct track or not.
ID проекту: 5924832

Про проект

10 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
10 фрілансерів(-и) готові виконати цю роботу у середньому за $181 USD
Аватарка користувача
Hi, I'll be happy to set up this project for you. Please feel free to message me if you need to discuss any questions you might have prior to award
$222 USD за 2 дні(-в)
4,9 (262 відгуки(-ів))
7,7
7,7
Аватарка користувача
Hi Goverman. I have looked at the samples and the criteria file. You have done a good job so far. A few points need discussion for better understanding. Kindly discuss. Regards. Usman.
$200 USD за 5 дні(-в)
5,0 (87 відгуки(-ів))
6,9
6,9
Аватарка користувача
Hi, excel vba expert here ready to start, I assure you high quality work done, want to share demo application developed in excel to give you an idea. Regards.
$111 USD за 7 дні(-в)
5,0 (34 відгуки(-ів))
5,3
5,3
Аватарка користувача
Hi, I have lots of experience with Excel data automation and processing using VBA and I can help you in short terms with this project.
$277 USD за 7 дні(-в)
4,9 (10 відгуки(-ів))
5,2
5,2
Аватарка користувача
Hello Groverman85c, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel database and VBA on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with Microsoft databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Office Excel,access and VBA to develop all types of requirements related ,and given my experience, i am persuaded to give you to give High quality of work delivery withing budget and time Best regards,
$210 USD за 5 дні(-в)
5,0 (10 відгуки(-ів))
5,0
5,0
Аватарка користувача
I will bring over 20 years experience with very strong Excel Forms Skills and exposure to CRM applications to bear on this role. I am available and ready to begin immediately.
$250 USD за 15 дні(-в)
0,0 (1 відгук)
2,9
2,9

Про клієнта

Прапор CHINA
Washington DC, China
4,0
8
Спосіб оплати верифіковано
На сайті з квіт. 21, 2010

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.