Search results

Refers to the chain. So Sheraton, for example, can be 0 days in 3 of the 4 cities, just needs to be used at least once in any city with the total number of days from table2 fulfilled.

Hi, Yes- as mentioned in the original post the constraints is basically table2, must meet those numbers by hotel. And must stay in each city at least once. My previous post mentions that using Solver I can complete this, but was seeking code to do this as it would very beneficial to learn from...

Hi, That would be a solution, but it would not necessarily be the cheapest most optimal solution. what I'm interested in is the most cheapest solution to solve. FYI I have solved by using Solver of course in Excel, and if anyone wants to know how to solve this using Solver I can certainly...

Thanks, yes- the hotels I listed with the city are the ones available in those cities.

Hi! I have very limited VBA skills but thought of a cool scenario that I was thinking of for my trip. I would like to know how you go about this or if it even possible in VBA, as I can only do very basic things. :confused: I have to travel to 4 cities. In those 4 cities are 3-4 hotels that I...

Hi! I'm very new and seek to enhance my limited VBA skills here.