Find Jobs
Hire Freelancers

Create an Excel Solution to replace an lotus aproach database

£20-250 GBP

Completed
Posted almost 8 years ago

£20-250 GBP

Paid on delivery
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.
Project ID: 10295787

About the project

11 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 4 days
5.0 (4 reviews)
2.2
2.2
11 freelancers are bidding on average £235 GBP for this job
User Avatar
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 in 15 days
5.0 (93 reviews)
6.1
6.1
User Avatar
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 in 3 days
4.8 (63 reviews)
5.6
5.6
User Avatar
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 in 10 days
4.2 (12 reviews)
5.8
5.8
User Avatar
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 in 5 days
5.0 (16 reviews)
4.8
4.8
User Avatar
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 in 5 days
4.8 (39 reviews)
4.7
4.7
User Avatar
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 in 3 days
5.0 (32 reviews)
4.4
4.4
User Avatar
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 in 3 days
5.0 (2 reviews)
2.7
2.7

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
10
Member since Apr 7, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.