Find Jobs
Hire Freelancers

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

$30-250 USD

En curso
Publicado hace alrededor de 10 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 5924832

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
10 freelancers están ofertando un promedio de $181 USD por este trabajo
Avatar del usuario
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 en 2 días
4,9 (262 comentarios)
7,7
7,7
Avatar del usuario
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 en 5 días
5,0 (87 comentarios)
6,9
6,9
Avatar del usuario
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 en 7 días
5,0 (34 comentarios)
5,3
5,3
Avatar del usuario
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 en 7 días
4,9 (10 comentarios)
5,2
5,2
Avatar del usuario
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 en 5 días
5,0 (10 comentarios)
5,0
5,0
Avatar del usuario
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 en 15 días
0,0 (1 comentario)
2,9
2,9

Sobre este cliente

Bandera de CHINA
Washington DC, China
4,0
8
Forma de pago verificada
Miembro desde abr 21, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.