Find Jobs
Hire Freelancers

Create an Excel Solution to replace an lotus aproach database

£20-250 GBP

Terminado
Publicado hace casi 8 años

£20-250 GBP

Pagado a la entrega
We currently have a lotus approach database system we are looking to replace with a complex Excel spreadsheet solution. I want the work done in Excel 2007 using VBA and SQL if required. It will also need to pull data from a Microsoft sql server database that sit in MS sql server 2008. The database will be too big to post on here but can show the connection details and give the table and column names. I will provide the spreadsheet with the columns in. The yellow headers are to be manually entered on gui, the green headers need to be automatically updated by being pulled from the database, using the sales_order as the look up to the tables shown in the image. It needs two guis, one to act as a data enty form that populates the spreadsheet and one to act as a search form to find existing records. Logo to be added to each gui included and a screenshot of the current form from approach included. Can do a team viewer session if required and can phone, I’m UK based. Have also included a locations list to be used as a mandatory entry drop down list on the data input gui.
ID del proyecto: 10295787

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 8 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
Adjudicado a:
Avatar del usuario
Hello there - I am an Excel genius so this is actually pretty trivial and can be done within three days. Thank you for being as detailed as you can be with the information required to build the Excel front-end. I can mock up a SQL Server back-end in my development lab to cover for your existing one, although a limited of sample exported from your database would be beneficial. I am also a native English speaker based in London so nothing will be lost in translation nor timezone. To confirm what you want: You want Excel front-end to add data to a table held in Excel that merges input data from the GUI with matching data pulled from the SQL back-end. You also want a second GUI that will allow you to query the data. I have a toolkit that will allow me to provide this within the time given in a robust and documented manner. I would propose talking on the phone to confirm the details and finalise any of your requirements before I start development and then again upon delivery. Happy to discuss while I choose the right freelancer for you and hope to here from you soon. /R.
£150 GBP en 4 días
5,0 (4 comentarios)
2,2
2,2
11 freelancers están ofertando un promedio de £235 GBP por este trabajo
Avatar del usuario
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£200 GBP en 15 días
5,0 (93 comentarios)
6,1
6,1
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£250 GBP en 3 días
4,8 (63 comentarios)
5,6
5,6
Avatar del usuario
Hello, sir. I am very interested from your project. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards
£400 GBP en 10 días
4,2 (12 comentarios)
5,8
5,8
Avatar del usuario
Hello, We have a team of 3 persons each with a great & talented mind. Two of us having experience of ~ 13 years and ~5 years in providing solutions for plugins, addin & addons for all the Microsoft office products(Office , excel , Power point , Access) developed in C# or VB.NET .3rd person having ~5 experience in providing all kind of solutions for BI DWH. As Freelancers also we have provided our services to various customers with 100% customer satisfaction. Below are our key area skills: · Expertise in VBA excel Macro · Expertise in C & C ++ Programming · Expertise in C# using .NET framework using Visual Studio 2012 and 2013 · Expertise in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application · Expertise in developing plugins, addin & addons for all the Microsoft office products(Office , excel , Power point , access and Power point) We always work to provide Best Delivery with 100 % customer satisfaction. We recently started our own company “Point5Nyble Your Needs, Our Dream”. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble
£205 GBP en 5 días
5,0 (16 comentarios)
4,8
4,8
Avatar del usuario
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
£222 GBP en 5 días
4,8 (39 comentarios)
4,7
4,7
Avatar del usuario
I CAN do this job, and do it well! If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulfill all of your requirements? IF SO, push the button "Hire me!" - I think it will be the beginning of a good partnership!!
£300 GBP en 3 días
5,0 (32 comentarios)
4,4
4,4
Avatar del usuario
Hello I would love to be considered for this project I am an excel expert with experience in excel program writing using VBA I can guarantee a top quality job with prompt delivery I look forward to your response Thanks Silas
£166 GBP en 3 días
5,0 (2 comentarios)
2,7
2,7

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
5,0
10
Miembro desde abr 7, 2002

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.