Lengkap

Write Excel VBA for multiple criteria, multiple table lookups

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.

Kemahiran: Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel vba match multiple columns, index match multiple criteria date range, index match multiple rows, excel lookup multiple criteria, index match multiple criteria rows and columns, excel vba index match multiple criteria, excel vba find row with multiple criteria, excel vba index match two columns, excel vba, pivot table, excel vba and pivot table 2, excel vba and pivot table -- 2, excel vba pivot table filter, excel vba filter table, excel vba range table, excel vba sheet table name

Tentang Majikan:
( 0 ulasan ) Tampa, United States

ID Projek: #16983709

Dianugerahkan kepada:

sloker18

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 dalam sehari
(20 Ulasan)
3.9

22 pekerja bebas membida secara purata $121 untuk pekerjaan ini

jaylancer43

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/article Lagi

$150 USD dalam 2 hari
(579 Ulasan)
8.2
cgullapalli

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 dalam sehari
(702 Ulasan)
7.7
$150 USD dalam 3 hari
(252 Ulasan)
7.3
schoudhary1553

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 Lagi

$150 USD dalam 2 hari
(248 Ulasan)
7.5
P0L

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 dalam 2 hari
(261 Ulasan)
7.0
aanvikm

Hello Sir, I am an expert with VBA and I can help you with this project. Thanks Aanvik

$172 USD dalam 3 hari
(52 Ulasan)
6.6
elqueabandona

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 dalam 3 hari
(198 Ulasan)
6.8
$155 USD dalam 3 hari
(69 Ulasan)
6.2
vlayausa

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 dalam 3 hari
(132 Ulasan)
5.8
sonarkaushik

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 Lagi

$194 USD dalam 3 hari
(61 Ulasan)
5.9
abhinovpankaj

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 Applicat Lagi

$122 USD dalam 3 hari
(60 Ulasan)
5.6
archanaoswal

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 (AP Lagi

$150 USD dalam 3 hari
(45 Ulasan)
5.4
prabakarm23

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 Serv Lagi

$111 USD dalam 5 hari
(60 Ulasan)
5.0
surekash7096

I have the expertise and experience in using Excel VBA to meet your requirement. ready to start work immediately.

$100 USD dalam 2 hari
(71 Ulasan)
5.3
aubrey03

A proposal has not yet been provided

$70 USD dalam 2 hari
(24 Ulasan)
4.9
jasalaz100

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 Lagi

$94 USD dalam sehari
(20 Ulasan)
4.7
nelumindralal

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 p Lagi

$100 USD dalam 3 hari
(14 Ulasan)
3.9
TechnoGuruu

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 Lagi

$99 USD dalam 3 hari
(7 Ulasan)
3.4
lherreraz

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 t Lagi

$90 USD dalam sehari
(8 Ulasan)
3.1
haleem0786

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 dalam 2 hari
(9 Ulasan)
3.0