gate

I have the following code that I'm using to try and count colour fill of cells in a specified range on another worksheet, and I can't get it to quite work how I want. The code that I can get working how I want is this: twowk = Sheets("PROD").Range("2:2").Find(What:="2WK GATE DATE"...

Good day all, I am working on a sheet for a school, and would like to create an automatic selection from one sheet to another. The idea is to have one sheet with various details, and then another with a form for a gate pass. What I am aiming for is the name to appear on the gate pass, if the...

Hi guys I've read a few posts on how to sum values across multiple sheets meeting a lookup criteria. None of the threads I've encountered have explained it this noob. I've tried the ExcelJeanie without luck, the version is incompatible with the Excel I am using. The data below is tab delimited...

Hi all, I need to solve an Airport Gate Assignment Problem using Excel. The output should include flight number, its respective gate and the time duration for which the gate will be occupied (A picture of which how the output should look like is shown below). Input parameters will be Flight...

Hi, is there a way to do a vlookup between 2 different lists where the "multiple" hits are returned - rather than only the first one? (we were using the vlookup, but it only gives us the "first" reference that it looks up) What we'd like is for the 1st instance to be put in Col B, the...

Dear All, I am working on Excel to make a decision tool. In this task I will have to construct a decision tree (Fault Tree) diagram. First of all A box will be inserted in which the text can be edited, then an AND gate shape or OR Gate shape will be added below it, then one, two or more...