Find Jobs
Hire Freelancers

Write Excel VBA for multiple criteria, multiple table lookups

$30-250 USD

Completed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
I am trying to create an algorithmic excel trade sheet based on multiple, optional criteria. The user will have many optional fields to fill out. The vba code will need to go look up values in different places depending on which tables the user selects. And this code will need to run over multiple cells. See the attached image. The user will (optionally) select a "load region", "station id 1", "station id 2". And then they will put in a max and min values for that load region, station id 1 or 2 temp and/or wind. There are also a couple more optional filters for the hour of the day, and a date filter. This criteria filter is used for each hour of the day (as seen by the 1,2,3..... on the right hand side of pic) So if that hour of the day passes all of the user criteria, then a "1" should show up under the hourly "1", "2", "3"... headings.
Project ID: 16983709

About the project

22 proposals
Remote project
Active 6 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
I am proficient with excel macro/VBA development, I can write the macro to perform the data lookup, feel free to message me if you are interested, looking forward to chat further and work on your project.
$50 USD in 1 day
5.0 (20 reviews)
3.9
3.9
22 freelancers are bidding on average $121 USD for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$150 USD in 2 days
5.0 (579 reviews)
8.2
8.2
User Avatar
HI, I am good at Excel and vba. Please share the file to review the complete scope of work. Looking forward to discuss further in the chat. I can add filters based on other conditions using vba. -Chandra
$100 USD in 1 day
5.0 (702 reviews)
7.7
7.7
User Avatar
Hello, I can help with you in your project Write Excel VBA for multiple criteria, multiple table lookups. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$150 USD in 2 days
4.9 (248 reviews)
7.5
7.5
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.
$100 USD in 2 days
4.9 (261 reviews)
7.0
7.0
User Avatar
Hello Sir, I am an expert with VBA and I can help you with this project. Thanks Aanvik
$172 USD in 3 days
5.0 (52 reviews)
6.6
6.6
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$150 USD in 3 days
5.0 (198 reviews)
6.8
6.8
User Avatar
Hello, I am proficient with Excel and VBA and I am interested in your project. I would love to hear more about it. Please contact me for more information.
$98 USD in 3 days
4.9 (132 reviews)
5.8
5.8
User Avatar
Sir, I am very able to create this excel vba macro to cater your requirement I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards
$194 USD in 3 days
4.7 (61 reviews)
5.9
5.9
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile
$150 USD in 3 days
4.9 (45 reviews)
5.4
5.4
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$122 USD in 3 days
4.9 (60 reviews)
5.6
5.6
User Avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc.,. hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
$111 USD in 5 days
5.0 (60 reviews)
5.0
5.0
User Avatar
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$94 USD in 1 day
4.9 (20 reviews)
4.7
4.7
User Avatar
I have the expertise and experience in using Excel VBA to meet your requirement. ready to start work immediately.
$100 USD in 2 days
4.6 (71 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
$70 USD in 2 days
4.7 (24 reviews)
4.9
4.9
User Avatar
Hello, I went thru the description Kindly send me the details and today can be started Lead time is committed to 3 days, just in case if any modification My previous projects and reviews can be seen in my profile I look forward to hearing from you Thanks Regards Thushara
$100 USD in 3 days
4.9 (14 reviews)
3.9
3.9
User Avatar
Hi, i have multiple years experience in excel, functions, macros etc. I will write vba code for your project. I understood details provided by you. Please give me this opportunity to work on your project. I will deliver quality work within timeframe. Thanks, Peter
$99 USD in 3 days
5.0 (7 reviews)
3.4
3.4
User Avatar
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, VBA etc. thanks
$160 USD in 2 days
4.8 (9 reviews)
3.0
3.0
User Avatar
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$90 USD in 1 day
5.0 (8 reviews)
3.1
3.1
User Avatar
Hello. I have read your project description carefully. I have rich experiences in DataProcessing and good skills Excel VBA. I understood your project and I can do your project. Contact me please. Best Regards.
$100 USD in 1 day
5.0 (4 reviews)
2.5
2.5

About the client

Flag of UNITED STATES
Tampa, United States
0.0
0
Payment method verified
Member since Mar 9, 2018

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.