This project was kinda thrown at me after the success of my last one which I required a LOT of help with. Due to the complexity of the If Then End statements required for this I decided I'll just ask for help overall.
Basically, it is an air traffic control worksheet designed to allow the operators to maintain an easy to use format for ensuring two aircraft are not assigned the same airspace.
The concept in itself is easy and the color is as well, it's when I have to factor in that an aircraft can be assigned its own space AND the surrounding space that makes it tricky.
Attached are two documents. The Excel sheet with the grid as I need it to be with a second sheet with a breakdown of the order of operations I need the macros to follow. The text document is basically the same thing as the second sheet in the Excel document except with examples of how the conflicts would arise. I'll provide a PowerPoint with screenshots of how it should look with certain data entered when I get the chance.
Not included in the order of operations is the need to revert the colors of the data table to clear and the data sheet to yellow when an entry is corrected from an error.
Now, normally I'd go through the trouble of pouring myself into books and trying to find help to problems online, but I don't have the time nor the Internet reliability for that. So, I need it done within 5 days, if possible, and due to the rush in which I need it I'm willing to pay upto 125$ via Paypal. If Paypal isn't good I'd be happy to find an alternative (I really need it done and I havn't a clue as to where to start).
Any help is greatly appreciated!