Find Jobs
Hire Freelancers

Create an Excel Solution to replace an lotus aproach database

£20-250 GBP

Concluído
Publicado há quase 8 anos

£20-250 GBP

Pago na 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 do Projeto: 10295787

Sobre o projeto

11 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 4 dias
5,0 (4 avaliações)
2,2
2,2
11 freelancers estão ofertando em média £235 GBP for esse trabalho
Avatar do Usuário
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 em 15 dias
5,0 (93 avaliações)
6,1
6,1
Avatar do Usuário
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 em 3 dias
4,8 (63 avaliações)
5,6
5,6
Avatar do Usuário
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 em 10 dias
4,2 (12 avaliações)
5,8
5,8
Avatar do Usuário
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 em 5 dias
5,0 (16 avaliações)
4,8
4,8
Avatar do Usuário
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 em 5 dias
4,8 (39 avaliações)
4,7
4,7
Avatar do Usuário
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 em 3 dias
5,0 (32 avaliações)
4,4
4,4
Avatar do Usuário
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 em 3 dias
5,0 (2 avaliações)
2,7
2,7

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
United Kingdom
5,0
10
Membro desde abr. 7, 2002

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.