Find Jobs
Hire Freelancers

Create Look up form from multiple ranges

£20-250 GBP

Closed
Posted almost 10 years ago

£20-250 GBP

Paid on delivery
Job is to create a form that can return a hauliage price for shipping goods around the UK, from UK to rest of EU, and rest of EU to UK. We would enter the following criteria to be presented with a price: Country from and to Postcode Size of pallet (choice of 6 different sizes) No of pallets (up to 6) Within each country postcodes are grouped into different zones. Each zone will return a price per pallet, varying according to the size of each pallet and how many pallets are being carried. There is a also a different price for going UK to Other country than from Other country to UK. The price presented will take all above factors into account and would be a total price rather than a price per pallet. We have all the data on paper, so the look up data would need to be put onto excel before the form is created. If you have any questions please contact through this site.
Project ID: 5847565

About the project

17 proposals
Remote project
Active 10 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
17 freelancers are bidding on average £142 GBP for this job
User Avatar
Dear Sir, I am happy to help you on this task. I have both advanced excel skills and a strong financial background which are essential in this project. I have already developed such currency look-up worksheets for various purposes and I assure you that I will create a dynamic and perfect model for you. If you are comfortable with my ratings and reliability, please share your existing date. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
£250 GBP in 3 days
5.0 (97 reviews)
6.2
6.2
User Avatar
Hi Liam. I have read the description and I have understood the project requirements mostly however a few things need further explanation. Kindly discuss in detail, so I may make a sample for you prior to formal awarding of the project. Regards. Usman.
£150 GBP in 3 days
5.0 (38 reviews)
6.0
6.0
User Avatar
Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award
£138 GBP in 1 day
5.0 (69 reviews)
6.0
6.0
User Avatar
Hello, This can be done with VBA code and formulae. A dialog box will allow you to enter the criteria or select them from drop-down lists, and the VBA code will do the rest accurately and efficiently. My only question has to do with the format of your data: Saying "we have all the data on paper", do you mean printed pages? And if yes, how many pages there are? Depending on the total number of pages, their importing into Excel sheets could be easy or time-consuming... That's why my bid is for 3 days; I can't give an accurate estimation without an answer to this question. For the coding part of the project I need max 1 day, but I'm not sure for the rest... A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs, of almost any kind and difficulty levels, for both training purposes and business. Looking forward to hear from you, Kind regards, Chriskerpini
£120 GBP in 3 days
5.0 (22 reviews)
4.7
4.7
User Avatar
I am the top ranking statistics and mathematics freelancer ( ranking 1) in freelancer.com.I am master in using excel formula and functions. I have gone through your project and can surely help you completing this.
£150 GBP in 7 days
5.0 (16 reviews)
4.6
4.6
User Avatar
Hi, Experienced Web Developer. Have worked on such script before. Recently I did an Ebay Delivery Price Estimator (data coming from Excel datasheet converted to Website Database). This will need HTML/PHP. Regards, Sid
£98 GBP in 2 days
5.0 (4 reviews)
4.1
4.1
User Avatar
Hello I am interested to work on this project I have few queries, please contact me through PM Waiting for your reply Thank You
£150 GBP in 3 days
4.3 (14 reviews)
3.8
3.8
User Avatar
Hi: I have sample form ready. I can share it with you. However, the website does not allow freelancer to communicate with employers unless the employer is the one who starts the conversation. Please connect with me to discuss more.
£166 GBP in 7 days
5.0 (6 reviews)
3.5
3.5
User Avatar
Dear liamdg. I'm interested in your project and can start immediately. Please provide info to key in the form. I can do data entry also creat formula in Excel to extract info by several conditions. Wait for your positive reply. Thank you.
£80 GBP in 7 days
5.0 (9 reviews)
3.5
3.5
User Avatar
Hi Liam, I was leading a data analytics division for one large company where I had full responsibility for all reporting done across the departments. I would like to support the project. If you award it to me, I can start within a day. Please don't hesitate to raise any additional questions that you might have. Kind regards Viktor
£120 GBP in 2 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Hi, My name is Dan. I am an expert in excel and can help you achieve the desired results. I am excellent with advanced lookup function with multiple ranges. I can code the formulas and embed them in the form so that the user can input the criteria and hits Calculate to display the results. It will be great if you could share the data range for me to have a look. Thanks ! Regards Dan
£116 GBP in 3 days
5.0 (3 reviews)
1.6
1.6
User Avatar
I have skill work with excel program,i can build system with excel for make simply report with nice view, please check my portfolio, and I am graduated in accounting courses. In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables. So I very confidence can give you what you want as soon as possible, I can start my work in any time.
£25 GBP in 3 days
3.9 (2 reviews)
1.7
1.7
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
4.0 (2 reviews)
1.6
1.6
User Avatar
I am good in excel and have experience of about 9 years, actually I enjoy working on excel. Prasoon
£244 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I handle large amount of data on daily basis and use reference ranges regularly. I can carry out your assignment with ease and speed.
£200 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work on very similar projects daily and should easily be able to create a form for you using the information you have. I am new to freelancer (hence the lack of reviews). If you send me a private message I can send you an example of a form I have created during my day job. Best regards, Richard
£111 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, I am interested to do this job as it is easy and simple. Please provide me details of the documents. Regards. Hyrandolf
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since Apr 23, 2014

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.