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.
Được trao cho:
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.
22 freelancer đang chào giá trung bình $121 cho công việc này
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
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
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.
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